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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access