Skip to main content

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.

FeedbackOpens in a new tab