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.

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

Other Resources

Connecting and Retrieving Data in ADO.NET