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.