Reply

Md. Elias Hossain Posted: 01-03-2010 6:32 AM

rated by 0 users

The use of DiffGram in ADO.NET

A DiffGram is an XML document that contains all of the data from DataSet object, includeing the orginal DataRow object information.

To save as a DiffGram, use the XmlWriteMode.DiffGram enumeration value as bellows:

DataSet objDSet = new DataSet();
objDataAdapter.Fill(objDSet);
// data manupulation code of the dataset/datatable object
objDSet.WriteXml(Server.MapPath("dXml.xml"), XmlWriteMode.DiffGram);

The DiffGram contains all of the DataRowVersion information in the XML document.

The Diffgram is mostly used in the environment where a user occasionally connects to a database to synchronize a disconnected DataSet object with the current information.

Thanks

Reply

Md Nazmul Ahsan replied on 01-05-2010 4:14 AM

rated by 0 users

"The Diffgram is mostly used in the environment where a user occasionally connects to a database to synchronize a disconnected DataSet"

If you have time can you please give us a sample demo/code or describe how it can be done generally? That will be so kind of you.

Thanks

Reply

Md. Elias Hossain replied on 01-06-2010 6:15 PM

rated by 0 users

Hello Mr. Nazmul,
    First of all I'm so sorry for late as I'm passing a busy and awful time. Yet I like to share with anybody anything.

    Also thanks a lot to you for asking real time sample. I've attached the file to my share file, you can see following the links bellow:

At My Files:
http://msdnbangladesh.net/members/dotnetmaestro/default.aspx   (at right-bottom side)

Direct Download:
http://msdnbangladesh.net/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.00.23.08/DiffGramTest_2D002D00_01_2D002D00_05_2D002D00_2010.zip

Reply

Md Nazmul Ahsan replied on 01-07-2010 4:39 AM

rated by 0 users

Thanks Elias vi for share this real time sample. Hope this can be help other to develop disconnected database sync. application.