Diffgrams

[Guest]

Hi

From my readings I noticed that I can save a dataset as a diffgram to a file after I do updates/inserts/deletes on the dataset. Then when I need to do more updates/inserts I reread the diffgram into a dataset and if I am connected to a database then use a dataadapter to update the database with changes. Is this correct in my assumption of how I can use the diffgram?

Thanks

JJ

 

[William Ryan eMVP]

JJ:

The diffgram is simply the mechanism that ADO.NET uses to persist the state
of a dataset. So, if you want to serialize it for instance, using WriteXML
and you need to get the rowstate info so you can update the db with it
later, you need to use the diffgram.

So technically it's a mechanism for preserving rowstate, but it's practical
purpose is just what you describe.

Hi,

From my readings I noticed that I can save a dataset as a diffgram to a

file after I do updates/inserts/deletes on the dataset. Then when I need to
do more updates/inserts I reread the diffgram into a dataset and if I am
connected to a database then use a dataadapter to update the database with
changes. Is this correct in my assumption of how I can use the diffgram?

 

[Guest]

Can I send this diffgram to a web service so that I can have the web service create a DataAdapter and update a Database
I was thinking I would call the web service if I can't connect I would then write the diffgram to file. If I can connect then send it to web service to update DB. What do u think

Thanks

JJ

 

[William Ryan eMVP]

Just send the dataset with the diffgram to the web service. Have a
datadapter already configured . Then, you can just call update b/c you have
your rowsxtate in place.

Can I send this diffgram to a web service so that I can have the web

service create a DataAdapter and update a Database?

I was thinking I would call the web service if I can't connect I would

then write the diffgram to file. If I can connect then send it to web
service to update DB. What do u think ?