Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

Working with DataAdapters 

A DataAdapter is used to retrieve data from a data source and populate tables within a DataSet. The DataAdapter also resolves changes made to the DataSet back to the data source. The DataAdapter uses the Connection object of the .NET Framework data provider to connect to a data source, and it uses Command objects to retrieve data from and resolve changes to the data source.

Each .NET Framework data provider included with the .NET Framework has a DataAdapter object: the .NET Framework Data Provider for OLE DB includes an OleDbDataAdapter object, the .NET Framework Data Provider for SQL Server includes a SqlDataAdapter object, the .NET Framework Data Provider for ODBC includes an OdbcDataAdapter object, and the .NET Framework Data Provider for Oracle includes an OracleDataAdapter object.

In This Section

Populating a DataSet from a DataAdapter

Describes how to fill a DataSet with tables, columns, and rows by using a DataAdapter.

Using Parameters with a DataAdapter

Describes how to use parameters with the command properties of a DataAdapter including how to map the contents of a column in a DataSet to a command parameter.

Working with DataAdapter Events

Describes DataAdapter events and how to use them.

Adding Existing Constraints to a DataSet

Describes how to add existing constraints to a DataSet.

Specifying Parameters and Return Values

Describes how to use input, output, and return values from a stored procedure by using a DataAdapter and a DataSet.

Retrieving Identity or Autonumber Values

Provides an example of mapping the values generated for an identity column in a Microsoft SQL Server table or for an Autonumber field in a Microsoft Access table, to a column of an inserted row in a table.

Setting Up DataTable and DataColumn Mappings

Describes how to set up DataTableMappings and ColumnMappings for a DataAdapter.



Describes the DataAdapter class and all of its members.


Describes the OdbcDataAdapter class and all of its members.


Describes the OleDbDataAdapter class and all of its members.


Describes the OracleDataAdapter class and all of its members.


Describes the SqlDataAdapter class and all of its members.

See Also

© 2015 Microsoft