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

Using the DbDataAdapter Class

The DbDataAdapter class is the base class for the OleDbDataAdapter and SqlDataAdapter classes. Here is the inheritance hierarchy of this class:

Object
   MarshalByRefObject
      Component
         DataAdapter
            DbDataAdapter

You can find the more notable public methods of DbDataAdapter objects in Table 22.13 and their more notable events in Table 22.14. (This class has no noninherited properties.)

Table 22.13: Noteworthy public methods of *DbDataAdapter* 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.

Table 22.14: Noteworthy public events of *DbDataAdapter* objects.
Event	Means
FillError	Occurs when an error happens while executing a fill operation.