Using the <i class="emphasis">DataAdapter</i> Class

Using the DataAdapter Class

The DataAdapter class is the base class for data adapters, which represent a bridge between a dataset and a database in a data provider. Here is the inheritance hierarchy of this class:

Object
   MarshalByRefObject
      Component
         DataAdapter

You can find the more notable public properties of DataAdapter objects in Table 22.11 and their more notable methods in Table 22.12. (This class has no non-inherited events.)

Table 22.11: Noteworthy public properties of *DataAdapter* objects.
Property	Means
AcceptChangesDuringFill	Gets/sets if a data row's AcceptChanges method is called after it is added to a table.
MissingMappingAction	Sets the action taken if there's no table mapping for new data.
MissingSchemaAction	Sets the action taken if new data does not match an existing data schema.
TableMappings	Gets the master mapping between source tables and a data table.

Table 22.12: Noteworthy public methods of *DataAdapter* objects.
Method	Means
Fill	Adds or updates rows in a data set to match those in the data source. Creates a table named "Table" by default.
FillSchema	Adds a table named "Table" to the specified DataSet, making the table's schema match that in the data source.
GetFillParameters	Gets the parameters to use when executing a SELECT statement in SQL.
Update	Updates the data store by calling the INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the given dataset.