Editing Data in Datasets
Editing the data in a DataSet is the process of manipulating the actual data in the individual DataTable objects that make up a dataset. You edit the data in data tables much as you edit the data in a table in any database — the process can include inserting, updating, and deleting records in the table.
In addition to changing to the actual data, you can also query a DataTable to return specific rows of data, for example, individual rows, specific versions of rows (original and proposed), only rows that have changed, and rows that have errors.
The following table provides links to the common tasks associated with editing and querying data in a dataset:
Insert new records into a data table.
Update existing records in a data table.
Assign a value directly to the specific column of a data row. For more information, see How to: Edit Rows in a DataTable.
Delete existing records from a data table.
Locate changed records in a data table.
Access different versions of a row in a data table.
Locate rows with errors in a data table.