MCAD/MCSD Training Guide (70-320): Developing XML Web Services and Server Components with Visual C#™ .NET and the Microsoft .NET Framework

Editing Data with ADO.NET

Now that you know how to retrieve data with ADO.NET, there's one other important database-related topic to cover: editing data. ADO.NET supports all the normal database operations of updating existing data, adding new data, and deleting existing data.

As you read the following sections, you need to keep in mind the distinction between the data model and the database. As you work with data in the DataSet object and its subsidiary objects, you alter the data in the data model. These changes are not reflected in the underlying database until and unless you call the Update() method of the SqlDataAdapter object. So far I've only been using the SqlDataAdapter object to move data from the database to the data model; in the ...