O'Reilly logo

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

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

Submitting Hierarchical Changes

When you modify data in multiple levels of a hierarchical DataSet, you will face two challenges when you submit those changes to your database. Let’s take a look at these scenarios.

Submitting Pending Insertions and Deletions

Say that you’re dealing with a hierarchy that contains orders and order details. The application you’ve built is an order entry system. The user has made a number of changes to the data and now wants to submit those changes to your database. The modified data in the DataSet contains new orders and new order details. The DataSet also contains orders and order details that are marked for deletion.

The challenge is to submit these changes in the proper order to comply with the referential integrity ...

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