How do you update a disconnected dataset

[Andrew]

I'm new to ADO.NET, and trying to understand...

Say you have a disconnected DataSet generated by "SELECT * FROM
MyTable WHERE ID = 1". The DataSet is edited and passed back into a
data component for update. For instance:

Persistence.Store(myDataSet);

Assuming Persistence.Store knows the data connection, how do you
update the database? Where does the SQL UPDATE statement come from?
The previous version of ADO saved the UPDATE statement, but ADO.NET
doesn't.

 

[William Ryan]

A commandbuilder for instance will infer the update logic from your select
command if you aren't using a Stored Proc and the table has a Key. You can
also use the DataAdapter configuration wizard to generate the update logic
or write your own. Check MSDN on this.... here's a really great article
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadonet/html/commandbuilder.asp

HTH,

Bill

 

[Greg]

You have 3 choices on building you commands:
1) manually
2) CommandBuilder
3) Data Form Wizard

I usually start with #3 and move to #1