RAD Studio for Microsoft .NET |  |

Using the Data Adapter Designer
See Also
Collapse All

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.

To invoke the commands

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.

See Also

ADO.NET Overview

ADO.NET Component Designers

Building a Windows Forms Database Application

Using the Connection Editor Designer

Using the Command Text Editor

Using the Generate DataSet Designer

Using the Data Adapter Preview

Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!