Home All Groups Group Topic Archive Search About

How to synchronize Dataset to database

Author
31 Mar 2005 6:59 AM
Arnab
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

Author
31 Mar 2005 7:27 AM
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/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataxmlwritemodeclasstopic.asp

I hope this helps,

Cor
Author
31 Mar 2005 1:18 PM
mboizeau
I agree with Cor,
use  Myds.WriteXml("c:\\myFile.xml", XmlWriteMode.DiffGram);

hope this helps


http://oraclevsmicrosoft.blogspot.com

AddThis Social Bookmark Button