System.Data.Common Namespace

Represents a set of data commands and a database connection that are used to fill a DataSet and update the data source.

DataAdapter Class Members

Show Inherited Members

Properties Visibility Name Value Type Accessibility public AcceptChangesDuringFill Boolean [ Get , Set ] public AcceptChangesDuringUpdate Boolean [ Get , Set ] public ContinueUpdateOnError Boolean [ Get , Set ] public FillLoadOption LoadOption [ Get , Set ] public MissingMappingAction MissingMappingAction [ Get , Set ] public MissingSchemaAction MissingSchemaAction [ Get , Set ] public ReturnProviderSpecificTypes Boolean [ Get , Set ] public TableMappings DataTableMappingCollection [ Get ]   Methods Visibility Name Parameters Return Type protected CloneInternals ( ) DataAdapter protected CreateTableMappings ( ) DataTableMappingCollection protected Dispose ( Boolean disposing ) Void public Fill ( DataSet dataSet ) Int32 protected Fill ( DataSet dataSet , String srcTable , IDataReader dataReader , Int32 startRecord , Int32 maxRecords ) Int32 protected Fill ( DataTable dataTables , IDataReader dataReader , Int32 startRecord , Int32 maxRecords ) Int32 protected Fill ( DataTable dataTable , IDataReader dataReader ) Int32 protected FillSchema ( DataSet dataSet , SchemaType schemaType , String srcTable , IDataReader dataReader ) DataTable public FillSchema ( DataSet dataSet , SchemaType schemaType ) DataTable protected FillSchema ( DataTable dataTable , SchemaType schemaType , IDataReader dataReader ) DataTable public GetFillParameters ( ) IDataParameter protected HasTableMappings ( ) Boolean protected OnFillError ( FillErrorEventArgs value ) Void public ResetFillLoadOption ( ) Void public ShouldSerializeAcceptChangesDuringFill ( ) Boolean public ShouldSerializeFillLoadOption ( ) Boolean protected ShouldSerializeTableMappings ( ) Boolean public Update ( DataSet dataSet ) Int32   Events Multicast Name Type multicast FillError FillErrorEventHandler

The DataAdapter serves as a bridge between a data source and a DataSet 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 SqlConnection and SqlCommand. For other OLE DB-supported databases, use the OleDbDataAdapter with its associated OleDbConnection and OleDbCommand objects.

DbDataAdapter   OleDbDataAdapter   SqlDataAdapter