Item 

Description 

Connection  

Specifies a connection from a list of live BdpConnections. You must select this item first to populate the other text boxes with usable data.  

Select  

Specifies that a SQL Select statement is to be generated by the BdpCommandBuilder. This statement must exist for the BdpCommandBuilder to be able to construct other statements, such as Update, Insert, or Delete statements. You can either supply your own Select statement in the BdpCommand object, or use this dialog to create one.  

Update  

Specifies that the BdpCommandBuilder is to generate an Update statement based on the Select statement.  

Insert  

Specifies that the BdpCommandBuilder is to generate an Insert statement based on the Select statement.  

Delete  

Specifies that the BdpCommandBuilder is to generate a Delete statement based on the Select statement.  

Generate SQL  

Generates SQL statements for the selected check box items.  

Optimize  

Specifies that, when possible, the BdpCommandBuilder is to generate optimized SQL statements for the selected check box items.  

Tables  

Displays a list of tables from the current database, represented by the current BdpConnection. To display a list of columns, select a table from the list. Select a table name to include it in the SQL statement that is currently visible in the SQL text box.  

Columns  

Displays a list of columns from a selected table. Select one or more column names to include them in the SQL statement that is currently visible in the SQL text box.