DataAdapter Class
Represents a set of data commands and a database connection that are used to fill the DataSet and update the data source.
For a list of all members of this type, see DataAdapter Members.
System.Object
System.MarshalByRefObject
System.ComponentModel.Component
System.Data.Common.DataAdapter
System.Data.Common.DbDataAdapter
[Visual Basic] MustInherit Public Class DataAdapter Inherits Component Implements IDataAdapter [C#] public abstract class DataAdapter : Component, IDataAdapter [C++] public __gc __abstract class DataAdapter : public Component, IDataAdapter [JScript] public abstract class DataAdapter extends Component implements IDataAdapter
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Remarks
The DataAdapter serves as a bridge between a DataSet and a data source for retrieving and saving data. The DataAdapter provides this bridge by mapping Fill, which changes the data in the DataSet to match the data in the data source, and Update, which changes the data in the data source to match the data in the DataSet.
If you are connecting to a Microsoft SQL Server database, you can increase overall performance by using the SqlDataAdapter along with its associated SqlCommand and SqlConnection objects. For OLE DB-supported data sources, use the DataAdapter with its associated OleDbCommand and OleDbConnection objects. For ODBC-supported data sources, use the DataAdapter with its associated OdbcCommand and OdbcConnection objects. For Oracle databases, use the DataAdapter with its associated System.Data.OracleClient.OracleCommand and System.Data.OracleClient.OracleConnection objects.
When an instance of DataAdapter is created, the read/write properties are set to initial values. For a list of these values, see the DataAdapter constructor.
Requirements
Namespace: System.Data.Common
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, .NET Compact Framework
Assembly: System.Data (in System.Data.dll)