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 TableAdapters 

You edit a TableAdapter when you want to change the schema of the adapter's table and the Fill method that fills the TableAdapter's associated data table. TableAdapters are created with a main Fill method that defines the schema of the associated data table. The main Fill method is based on the query or stored procedure you entered when you originally configured the TableAdapter; it is the first (topmost) method below the data table on the Dataset Designer.

TableAdapter with multiple queries

Any changes made to the TableAdapter's main Fill method are reflected in the schema of the associated data table. For example, removing a column from the query in the main Fill method also removes the column from the associated data table. Additionally, removing the column from the main Fill method removes the column from any additional queries for that TableAdapter.

You edit TableAdapters with the TableAdapter Configuration Wizard in the Dataset Designer.

NoteNote

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

To edit a TableAdapter

  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 you want to edit.

  3. Right-click the TableAdapter name and choose Configure.

    The TableAdapter Configuration Wizard opens, ready for you to modify the query or stored procedure that fills the TableAdapter's associated data table.

  4. Complete the TableAdapter Configuration Wizard with the changes you want.

See Also

Community Additions

ADD
Show:
© 2015 Microsoft