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.