How to synchronize Dataset to database

[Guest]

In our project we fetched data into dataset from the database.
Now we are storing the data in a XML File from the dataset.
The modified DataSet is kept in the XML File And dataset is closed.
Later at the time of saving we are building the dataset from the XML file
and then want to save the dataset into database.
We are not able to save the dataset being populated from an xml file into
database.
Kindly suggest a remedy for our problem

Thanks in advance
Regards
Arnab

 

[Cor Ligthert]

Arnab,

I am not sure what you are doing, because when you do no updates in your
dataset, there should nothing be updated.

When you do, than you have probably to use this one (diffgram)

http://msdn.microsoft.com/library/d...tml/frlrfsystemdataxmlwritemodeclasstopic.asp

I hope this helps,

Cor

 

[mboizeau]

I agree with Cor,
use Myds.WriteXml("c:\\myFile.xml", XmlWriteMode.DiffGram);

hope this helps


http://oraclevsmicrosoft.blogspot.com