Essential ADO.NET

5.8. The DataSet Event Model

The DataTable class has an event model that permits you to catch inserts, updates, and deletes when they occur in the DataTable. The DataRowChanged delegate is used for this. You can cancel inserts, change columns, or tag each DataRow with a row-specific error message through the RowError class. This process, discussed in Chapter 4, occurs inside the DataSet before an attempt is made to update the database.

You can further customize the update process by using the event model in DataAdapter. When DataAdapter.Update is called, RowUpdating and RowUpdated events are fired for each DataRow that has changes. You can catch RowUpdating events and refine, change, or cancel the updates on a per-DataRow basis. As shown in ...