Step 2 of 4: Configuring a Data Connection and Data Adapter
In This Topic
In this step, you will add one data adapter for the table: products.
-
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.
-
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.
-
The Use SQL Statements is selected by default, click Next.
-
Copy and paste the following SQL statement in the textbox of the Data Adapter Configuration Wizard:
SELECT Products.*
FROM Products
-
Click Next.
-
Click Finish.