# Step 2 of 4: Configuring a Data Connection and Data Adapter

## Content

In this step, you will add one data adapter for the table: products.

1. From the Toolbox, double-click the OleDbDataAdapter component. If it’s not in the toolbox, right-click and select **Choose Items**. On the .NET Framework Components tab in the dialog box, select **OleDbDataAdapter**. The OleDbDataAdapter appears in the component tray and the **Data Adapter Configuration Wizard** appears.
2. In the Data Adapter Configuration Wizard, choose the connection you wish to use for the data adapter from the drop-down listbox (in this case, **C:\\Users\\UserName\\Documents\\ComponentOne Samples\\Common\\C1NWind.mdb**) and then click **Next**.
3. The Use SQL Statements is selected by default, click **Next**.
4. Copy and paste the following SQL statement in the textbox of the **Data Adapter Configuration Wizard**:

> SELECT Products.\*
> FROM Products

5. Click **Next**.
6. Click **Finish**.