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.