The Data Adapter contains, at a minimum, a SQL Select statement of the SELECT command property. You can enter this statement yourself, or using the Data Adapter designer you can construct the Select, along with the Update, Insert, and Delete statements. The BdpCommandBuilder constructs the Update, Insert, and Delete statements based on the tables and columns you have selected. The Data Adapter designer uses a live connection to retrieve metadata from which you can build the appropriate SQL statements for manipulating the data you want to move from a DataSet back into your database.

1. Select a connection from the Connection drop-down list box. This must be a BdpConnection you have already defined. This populates the Tables and Columns list boxes with data from the database.
2. Select a table from the Tables list box.
3. Select each column that you want to appear in your SQL statements.
4. Select the check box next to each statement type you want to generate.
5. Click the Generate SQL button.
6. Edit the generated text if desired, or reselect different columns and click Generate SQL again.
7. Click OK.
   Note: Command components are automatically created as needed based on the selections in the dialog.