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.
- 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 be used to resolve problems with the data in the row 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.