- Fill the tables for your DataSet using a stored procedure or SQL.
- Display the data in various DataTable objects within your DataSet by either binding to a control or looping through the rows in the tables.
- Change data in individual DataTable objects by adding, modifying, or deleting DataRow objects.
- Invoke the GetChanges( ) method to create a second DataSet that features only the changes to the data.
- Check for errors in the second newly created DataSet by examining the HasErrors property. If there are errors, check the HasErrors property of each DataTable in the DataSet. If the table has errors, invoke the GetErrors( ) method of the DataTable and get back an array of DataRow objects with errors. On each row you can examine the RowError property for specific information about the error, which you can then resolve.
- Merge the second Data Set with the first.
- Call the Update( ) method on the DataAdapter object and pass in the second (changed) DataSet.
- Invoke the AcceptChanges( ) method on the DataSet, or invoke RejectChanges( ) to cancel the changes.
This way is typically use for update Modified DataSet.
See some details about this in following article:
http://www.akadia.com/services/dotnet_update_form.html
