TableAdapters provide communication between your application and a database. More specifically, a TableAdapter connects to a database, executes queries or stored procedures, and either returns a new data table populated with the returned data or fills an existing DataTable with the returned data. TableAdapters are also used to send updated data from your application back to the database.
You can create TableAdapters by performing one of the following actions:
For an introduction to TableAdapters, see TableAdapter Overview.
.gif) Note |
|---|
| The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings. |
Creating TableAdapters with the TableAdapter Configuration Wizard
The TableAdapter Configuration Wizard creates a single TableAdapter based on information you provide to the wizard.
To create a TableAdapter with the TableAdapter Configuration Wizard
Creating TableAdapters with the Data Source Configuration Wizard
The Data Source Configuration Wizard creates a TableAdapter for each database object selected during the running of the wizard. After completing the Data Source Configuration Wizard, you can view the TableAdapters created by opening the dataset in the Dataset Designer. For more information, see How to: Open a Dataset in the Dataset Designer.
To create a TableAdapter with the Data Source Configuration Wizard
Creating TableAdapters from Server Explorer Database Objects
A single TableAdapter is created for each database object that you drag onto the Dataset Designer.
To create a TableAdapter from Server Explorer database objects
See Also