This documentation is archived and is not being maintained.

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.

Adding Existing Constraints to a DataSet

Describes how to add existing constraints to a DataSet.

Setting Up DataTable and DataColumn Mappings

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

Reference

DataAdapter

Describes the DataAdapter class and all of its members.

OdbcDataAdapter

Describes the OdbcDataAdapter class and all of its members.

OleDbDataAdapter

Describes the OleDbDataAdapter class and all of its members.

OracleDataAdapter

Describes the OracleDataAdapter class and all of its members.

SqlDataAdapter

Describes the SqlDataAdapter class and all of its members.

See Also

Show: