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.