Two-stage update process and the role of the Data Row Version in a successful update A dataset contains collections of tables, which contain a collections of rows.If you intend to update an underlying data source later, you must use the methods on the Data Table.Constraints are automatically disabled when the Merge method is invoked on a dataset.
By using this information, processes can determine what has changed in the dataset and can send appropriate updates to the data source.
The Row State property of a Data Row object is a value that provides information about the status of a particular row of data.
However, you can also use different adapters, for example, to move data from one data source to another or to update multiple data sources.
If you aren't using data binding, and are saving changes for related tables, you have to manually instantiate a variable of the auto-generated Table Adapter Manager class, and then call its Udpate All method.
Data Row Collection property when adding or removing rows.
Those methods perform the change tracking that's needed for updating the data source.If you do send the changes back to the database, then a second step is required.If you aren't using data-bound controls, then you have to manually call the Update method of the same Table Adapter (or data adapter) that you used to populate the dataset.For more information about suspending events, see Turn off constraints while filling a dataset.When you update a record in a dataset, there is the possibility of an error.For example, you might inadvertently write data of the wrong type to a column, or data that's too long, or data that has some other integrity problem.