How to: View the Queries in a TableAdapter

A TableAdapter can contain several queries:

The main Fill query, which is used to define the schema of the TableAdapter's data table.
Additional queries that can be used to fill the table as well (the additional queries do not define the schema of the table, but they do need to return data that conforms to that schema, or return a scalar value).
Additionally, depending on the structure of the main Fill query, a TableAdapter can contain INSERT, UPDATE, and DELETE queries (typically referred to as commands) that are used to send updated data back to the database.

TableAdapter with multiple queries:

TableAdapter with multiple queries

To view these queries, use the following procedures to open them in the designer:

Viewing a TableAdapter's Main Fill Query

Open the dataset in the Dataset Designer. For more information, see How to: Open a Dataset in the Dataset Designer.
Right-click the TableAdapter's title bar and choose Configure.

The TableAdapter Configuration Wizard opens, displaying the SQL statement used to fill the table or the stored procedure that is called to fill the table.

Open the dataset in the Dataset Designer. For more information, see How to: Open a Dataset in the Dataset Designer.
Select the TableAdapter by clicking its title bar.
In the Properties window, locate and expand the command you want to view.
The SQL statement or stored procedure name is viewable in the CommandText property.

Open the dataset in the Dataset Designer. For more information, see How to: Open a Dataset in the Dataset Designer.
Right-click the TableAdapter query you want to view and select Configure.

The TableAdapter Query Configuration Wizard opens, displaying the SQL statement used to fill the table or the stored procedure that is called to fill the table.