Export (0) Print
Expand All

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.

See Also

Community Additions

ADD
Show:
© 2014 Microsoft