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.6. Updating a Database through DataAdapter

The disconnected update pattern is a good choice when you have a single user per DataSet. The DataSet class supports this pattern of data access. Data is read into DataSet using DataAdapter. The DataAdapter class can sever the connection, and multiple updates can be made in disconnected mode. DataSet keeps a cache of these updates. The changes are visible immediately within DataSet itself but can be flushed back to a data store. Attempting to set a DataColumn to an incorrect value (for example, attempting to set a non-nullable column to DBNull.Value) results in an error at column update time in DataSet, rather than when the change is flushed to a database. This means that by specifying constraints ...

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