Datasets and Diffgrams

[Guest]

Hi,

I am wondering if I create a diffgram dataset and I save the dataset to file and then want to commit the dataset to the database. I would assume that I would use a DataAdapter to help commit changes to db, correct?

Is there any special command in the DataAdapter in order to save dataset to database outside of the Update command? Like in the Update property is there any special option type that needs to be included in order to inform the DataAdapter what I am trying to accomplish?


Will a diffgram dataset work for Access as well as Sql Server?

Thanks,

JJ

 

[William Ryan eMVP]

The Diffgram option has to deal with DataSets more than DataAdapters per se,
although the DataAdapter looks at the diffgram to determine what it's going
to update. It's most practical use is with a DataAdatper, but one could
still take advantage of the diffgram in a scenario where no dataadapter is
ever being used. So anyway, let's say that you had a SqlServer database and
an access db and the schemas match perfectly (and no fields are being used
that aren't common to both db's). Anyway, you fill a dataset from the
SqlServer, change everything with the dataset and want to save those changes
back to the access db. As long as you have the update/insert/delete logic
to handle it, you can call DataAdapter.Update with a new adapter pointing to
access, and those changes will be reflected.

Hi,

I am wondering if I create a diffgram dataset and I save the dataset

to file and then want to commit the dataset to the database. I would assume
that I would use a DataAdapter to help commit changes to db, correct?

Is there any special command in the DataAdapter in order to save dataset

to database outside of the Update command? Like in the Update property is
there any special option type that needs to be included in order to inform
the DataAdapter what I am trying to accomplish?