DataSet binding/updates

[Random]

If I base my DataSet on a schema (an .xsd file), and then bind the controls
on my form to the necessary fields in a DataTable in the DataSet, how then
would I use the SqlDataAdapter to put all this information into the
database?

Loading the DataSet from a schema is easier than basing it on a query since
there are several tables involved.

 

[W.G. Ryan eMVP]

You'll need an adapter configured for each of the tables- you can just call
update on a given adapter with its corresponding table in the dataset.

 

[Cor Ligthert]

Random,

In addition to Bill,

Although there is not much differentce with the method from Bill can you use
as well one dataadapter, however than you have to set the right commands
(updateCommand, the InsertCommand and the DeleteCommand) in advance.

I hope this helps?

Cor