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

Using the SqlDataAdapter Class

The SqlDataAdapter class represents a bridge between a dataset and an SQL Server database. Here is the inheritance hierarchy of this class:

Object
   MarshalByRefObject
      Component
         DataAdapter
            DbDataAdapter
               SqlDataAdapter

You can find the more notable public properties of SqlDataAdapter objects in Table 22.18, their more notable methods in Table 22.19, and their more notable events in Table 22.20.

Table 22.18: Noteworthy public properties of *SqlDataAdapter* objects.
Property	Means
DeleteCommand	Gets/sets the SQL for deleting records.
InsertCommand	Gets/sets the SQL for inserting new records.
SelectCommand	Gets/sets the SQL for selecting records.
UpdateCommand	Gets/sets the SQL for updating records.

Table 22.19: Noteworthy public methods of *SqlDataAdapter* objects.
Method	Means
Fill	Adds or refreshes rows to a dataset to make them match the rows in a data store.

Table 22.20: Noteworthy public events of *SqlDataAdapter* objects.
Event	Means
RowUpdated	Occurs when a row is updated.
RowUpdating	Occurs when a row is being updated.