Add and configure an OLE-DB adapter

You use an OLE-DB adapter to exchange data between a data source and a dataset. In most cases, this means data is read from a database into a dataset, and then changed data from the dataset is written back to the database.

However, an OLE-DB adapter can move data between any OLE-DB provider and the resultant dataset. An OleDbAdapter item returns a dataset that contains one or more data tables.

Prerequisite

Before you can add an OLE-DB adapter, add and configure an OLE-DB data source.

To add an OLE-DB adapter

1. In the Project Explorer, right-click the data source, point to Add Item, point to OLE DB Connector, and then select Adapter. An OleDbAdapter item appears.

   

2. Rename the adapter with a meaningful name.

3. Configure the properties. For guidance in configuring the properties, see OLE-DB connector adapter properties.

Related topics

• OLE-DB connector

• Add and configure an OLE-DB data source

• Add and configure an OLE-DB data connection