|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. ArchiveDisclaimer|
How to: Edit TableAdapter Queries
You edit TableAdapter queries with thein 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 .)
If theopens 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 .
To edit a TableAdapter query
Open the dataset in the Dataset Designer. For more information, see.
Select the TableAdapter query you want to edit.
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.
Complete the TableAdapter Query Configuration Wizard with the changes that you want. For more information, see.