Preparing a CacheDataAdapter: Overview
A CacheDataAdapter connects a DataSet with a data source. To initialize a CacheDataAdapter you must do the following:
-
Initialize the adapter with the SQL SELECT command. The adapter fills the data set based on this command.
-
Create CacheCommand objects for each of the SQL commands that the adapter supports. In this case, the adapter supports INSERT, UPDATE, and DELETE.
-
For each CacheCommand object, create CacheParameter objects to represent the parameters in its SQL. Add the CacheParameter objects to the CacheCommand objects.