insertions, updates, and deletions in many cases, it is important to send changes made through the dataset to the data source in the order in which they are sent. For example, if you have updated the primary key value of an existing row and added a new row with a new primary key value, be sure to process the update before processing the insert. You can use the Select method of the DataTable to return only a DataRow array that references a specific RowState. You can then pass the returned DataRow array to the DataAdapter Update method to handle the modified row. You can control the order in which insertions, updates, and deletions are processed by specifying a subset of rows to update. DataTable Table= dataset.tables["Customers"];//First process deletes.Adapter. Update (table. Select (NULL,NULL, dataviewrowstate.deleted));//Next process updates.Adapter. Update (table. Select (NULL,NULL, DataViewRowState.ModifiedCurrent));//Finally, Process inserts.Adapter. Update (table. Select (NULL,NULL, dataviewrowstate.added));
SqlDataAdapter updating data