Export (0) Print
Expand All
4 out of 11 rated this helpful - Rate this topic

Editing Data in Your Application 

After your dataset is populated with data, you will typically add, edit, or delete some of the data before sending it back to the data source or to another process or application. Since each record in a dataset is represented by a DataRow object, changes to a dataset are accomplished by working with individual rows.

NoteNote

In Windows Forms, the data-binding architecture takes care of sending changes from data-bound controls to the dataset, and you do not have to explicitly update the dataset with your own code. For more information, see Windows Forms Data Binding.

Datasets maintain multiple versions of data rows in order to locate the original records in a data source. Before performing an update to the data source, you may want to examine specific rows. The topics in this section provide details on determining if records have changed, as well as retrieving particular versions of records.

The following topics provide details on adding, editing, and deleting rows in data tables, and how to work with rows in various stages of an application.

In This Section

Editing Data in Datasets Overview

Provides information on the many tasks that manipulate data in a dataset.

How to: Add Rows to a DataTable

Provides the steps to create DataRow objects and add them to a data table.

How to: Edit Rows in a DataTable

Provides the steps for editing an existing row of data in a data table.

How to: Delete Rows in a DataTable

Provides the steps to remove specific rows of data in a data table.

How to: Turn Off Constraints While Filling a Dataset

Provides details for temporarily disabling constraint checking in a dataset.

How to: Commit Changes in a Dataset

Provides information and details for accepting changes that have been made to data in a dataset.

How to: Check for Changed Rows

Provides the steps to determine if data has been changed in a dataset.

How to: Retrieve Changed Rows

Provides details for returning rows of data that have been changed since last accepting any changes.

How to: Locate a Specific Row in a DataTable

Provides details for finding data in a data table using either a primary key value, or a column value.

How to: Get Specific Versions of a DataRow

Provides details for returning specific rows of data using the DataRowVersion enumeration.

How to: Locate Rows that Have Errors

Provides details for finding data in a data table that has been marked with an error.

Reference

DataSet

Represents an in-memory cache of data.

DataTable

Represents one table of in-memory data.

DataRow

Represents a row of data in a DataTable.

DataColumn

Represents the schema of a column in a DataTable.

DataRowVersion

Describes the version of a DataRow.

RowState

Gets the state of a DataRow object.

AcceptChanges

Commits all the changes made to this DataSet since it was loaded or since the last time AcceptChanges was called.

HasChanges

Gets a value indicating whether the DataSet has changes, including new, deleted, or modified rows.

GetChanges

Gets a copy of the DataSet containing all changes made to it since it was last loaded, or since AcceptChanges was called.

HasErrors

Gets a value indicating whether there are errors in any of the DataTable objects within this DataSet.

Related Sections

ADO.NET DataSet

Provides topics about what datasets are and how to use them.

Using DataSets in ADO.NET

Describes how to create and customize DataSet objects.

Creating and Using DataTables

Describes how to create and customize DataTable objects.

Preparing Your Application to Receive Data

Provides links to topics explaining what datasets are, how to create new datasets, and how to create and edit the individual objects they are made of.

Getting Started with Data Access

Provides links to topics on creating applications that work with data, using Visual Studio.

Connecting to Data in Visual Studio

Provides links to topics on connecting your application to data with design time tools, and ADO.NET connection objects, using Visual Studio.

Fetching Data into Your Application

Provides links to topics describing how to load data into datasets, and how to execute SQL statements and stored procedures.

Displaying Data on Forms in Windows Applications

Provides links to topics that explain how to display data on Windows Forms through data-bound controls.

Validating Data

Provides links to topics describing how to add validation to a dataset during column and row changes.

Saving Data

Provides links to topics explaining how to send updated data from an application to the database.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.