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 safe for multithreaded operations. 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 - Windows CE .NET

Assembly: System.Data (in System.Data.dll)

See Also

DataAdapter Members | System.Data.Common Namespace