Manipulating Data in a DataTable
After creating a DataTable in a DataSet, you can perform the same activities that you would when using a table in a database. You can add, view, edit, and delete data in the table; you can monitor errors and events; and you can query the data in the table. When modifying data in a DataTable, you can also verify whether the changes are accurate, and determine whether to programmatically accept or reject the changes.
In This Section
- Adding Data to a Table
Explains how to create new rows and add them to a table.
- Viewing Data in a Table
Describes how to access the data in a row, including original and current versions of the data.
- Using the Load Method
Describes the use of the Load method to fill a DataTable with rows.
- Editing Data in a Table
Explains how to modify the data in a row, including suspending the changes to a row until the proposed changes are verified and accepted.
- Row States and Row Versions
Provides information about the different states of a row.
- Deleting a Row from a Table
Describes how to remove a row from a table.
- Adding and Reading Row Error Information
Explains how to insert error information per row, to help resolve problems with the data within an application.
- Accepting or Rejecting Changes to Rows
Explains how to accept or reject the changes made to a row.
- Working with DataTable Events
Provides information about the events available for use with a DataTable, including events when column values are modified and rows are added or deleted.