Chapter 11: Using DataSet Objects to Modify Data

Overview

In chapter 10, you saw how to use a DataSet to store a copy of the rows retrieved from the database. In this chapter, you'll learn how to modify the rows in a DataSet, and then push those changes to the database via a DataAdapter.

Featured in this chapter:

  • The DataTable, DataRow, and DataColumn classes

  • Adding restrictions to DataTable and DataColumn objects

  • Finding, filtering, and sorting DataRow objects in a DataTable

  • Modifying rows in a DataTable and pushing those changes to the database

  • Using stored procedures to add, modify, and remove rows from the database

  • Using a CommandBuilder object to automatically generate SQL statements

  • Exploring the DataAdapter and DataTable events

  • Dealing with update failures

  • Using transactions with a DataSet

  • Modifying data using a strongly typed DataSet




Mastering C# Database Programming
Mastering the SAP Business Information Warehouse: Leveraging the Business Intelligence Capabilities of SAP NetWeaver
ISBN: 0764596373
EAN: 2147483647
Year: 2003
Pages: 181

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net