Share via


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

  • 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.
  • 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.

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