O'Reilly logo

Essential ADO.NET by Bob Beauchemin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required