This documentation is archived and is not being maintained.

Manipulating Data in a DataTable (ADO.NET)

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.

Adding Data to a DataTable (ADO.NET)

Explains how to create new rows and add them to a table.

Viewing Data in a DataTable (ADO.NET)

Describes how to access the data in a row, including original and current versions of the data.

Loading DataTable Data (ADO.NET)

Describes the use of the Load method to fill a DataTable with rows.

Editing Data in a DataTable (ADO.NET)

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 (ADO.NET)

Provides information about the different states of a row.

Deleting DataRows (ADO.NET)

Describes how to remove a row from a table.

Handling DataRow and DataColumn Errors (ADO.NET)

Explains how to insert error information per row, to help resolve problems with the data within an application.

AcceptChanges and RejectChanges (ADO.NET)

Explains how to accept or reject the changes made to a row.