Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

How to: Edit TableAdapter Queries

You edit TableAdapter queries with the TableAdapter Query Configuration Wizard in the Dataset Designer. You should modify a TableAdapter query when it no longer suits the needs of your application. (Alternatively, you can create additional queries on the TableAdapter. For more information on adding new queries, see How to: Create TableAdapter Queries.)

NoteNote:

If the TableAdapter Configuration Wizard opens instead of the TableAdapter Query Configuration Wizard, you might have selected the TableAdapter's main Fill query and not one of the TableAdapter's additional queries. For information on editing the TableAdapter's main Fill query, see How to: Edit TableAdapters.

TableAdapter with multiple queries

To edit a TableAdapter query

  1. Open the dataset in the Dataset Designer. For more information, see How to: Open a Dataset in the Dataset Designer.

  2. Select the TableAdapter query you want to edit.

  3. Right-click the TableAdapter query and select Configure.

    The TableAdapter Query Configuration Wizard opens, ready for you to modify the query or stored procedure for that query.

  4. Complete the TableAdapter Query Configuration Wizard with the changes that you want. For more information, see TableAdapter Query Configuration Wizard.

Community Additions

ADD
Show:
© 2015 Microsoft