Updating dataset to database
The order of command execution will also follow the indices of the .If you are updating two or more related tables, then you should include all the update logic within a transaction.
For more information on saving data from a single data table back to a database, see When updating related tables in a dataset, it is important to update in the proper sequence to reduce the chance of violating referential integrity constraints.
You must explicitly set the commands before calling Update.
If Update is called and the appropriate command does not exist for a particular update (for example, no Delete Command for deleted rows), an exception will be thrown.
Since each record in a dataset is represented by a Data Row object, changes to a dataset are accomplished by updating and deleting individual rows.
Additionally, new records can be inserted into the dataset by adding new Data Row objects to the Data Table objects' Rows collection.
Search for updating dataset to database:
The goal in this scenario is to transfer data stored in a Data Set object to the database.