These are the most commonly used methods of a
DataAdapter
:Fill
FillSchema
Update
Executes the Select command to fill the
DataSet
object with data from the data source. It an also be used to update (refresh) an existing table in a DataSet
with changes made to the data in the original data source if there is a primary key in the table in the DataSet
.
Uses the
SelectCommand
to extract just the schema for a table from the data source, and creates an empty table in the DataSet
object with all the corresponding constraints.
Calls the respective
InsertCommand
, UpdateCommand
, or DeleteCommand
for each inserted, updated, or deleted row in the DataSet
so as to update the original data source with the changes made to the content of the DataSet
. This is a little like the UpdateBatch
method provided by the ADO Recordset
object, but in theDataSet
, it can be used to update more than one table.
No comments:
Post a Comment