Chapter 15. Updating the Data Source

This chapter discusses how to use the DataAdapter object to submit changes made to a DataSet back the data source. First, the CommandBuilder object, which is easy to use but provides only limited functionality, is introduced, and an overview of using it to submit changes is presented. Following that, using custom command logic to submit the updates is described. Finally, techniques to handle common tasks such as retrieving new AutoIncrement values, refreshing updated data, updating data in related tables, and handling concurrency issues are discussed.