Using SqlDataAdapter Objects to Submit Updates

You have the following three choices when it comes to generating the updating logic that your SqlDataAdapter objects use to submit changes to your database:

  1. Use code to manually configure your SqlDataAdapter objects.

  2. Use a SqlCommandBuilder at run time.

  3. Use the Visual Studio wizards at design time.

Each of these methods has benefits and drawbacks. In the following sections, I explain both in detail.

Get Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.