Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition

Chapter 11. Advanced Updating Scenarios

In this chapter:

Refreshing a Row After Submitting an Update

Retrieving Newly Generated Auto-Increment Values

Submitting Hierarchical Changes

Isolating and Reintegrating Changes

Handling Failed Update Attempts

Working with Distributed Transactions

Batch Queries

SQL Bulk Copy

DataSet Objects and Transactions

When Handling Advanced Updating Scenarios, Use ADO.NET

Questions That Should Be Asked More Frequently

In Chapter 10, you learned how to use the updating features of the SqlDataAdapter class to submit changes to your database. At this point, you should be comfortable generating updating logic by using either the Microsoft Visual Studio TableAdapter or Data Adapter Configuration Wizard or the SqlCommandBuilder object. ...