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.