TableAdapters provide communication between your application and a database by executing SQL statements and stored procedures against a database. In addition to the standard functionality of a DataAdapter, TableAdapters provide additional queries that share a common schema with the associated typed DataTable. The TableAdapter loads the returned data into its associated data table in your application, or returns new data tables already populated with data.
- TableAdapter Overview
Explains what TableAdapters are and the tools available to create them.
- TableAdapter Configuration Wizard
Describes how to run the wizard and provides details for each wizard screen.
- TableAdapter Query Configuration Wizard
Describes how to run the wizard and provides details for each wizard screen.
- Working with Null Values in TableAdapters
Provides the steps for enabling null values in TableAdapter parameters.
- How to: Create TableAdapters
Provides the steps to create a new TableAdapter.
- How to: Edit TableAdapters
Provides the steps to edit existing TableAdapters.
- How to: Create TableAdapter Queries
Provides the steps to add a query to an existing TableAdapter.
- How to: Edit TableAdapter Queries
Provides the steps to edit existing TableAdapter queries.
- How to: View the Queries in a TableAdapter
Explains how to view the existing queries in a TableAdapter.
- How to: Extend the Functionality of a TableAdapter
Provides the steps for creating a partial class for the TableAdapter where you can add code in addition to the designer-generated code.
- How to: Create Parameterized TableAdapter Queries
Provides the steps to create TableAdapter queries that accept parameters.
- How to: Add Global Queries to a Dataset
Provides the steps to create a TableAdapter with a query that returns a single value.
- How to: Execute TableAdapter Queries
Provides the steps to execute TableAdapter queries.
- Walkthrough: Creating a TableAdapter with Multiple Queries
Provides step-by-step instructions for creating a TableAdapter and adding a query to it.
- Connecting to Data in Visual Studio
Provides links to topics explaining how to create connections to different sources of data.
- Preparing Your Application to Receive Data
Provides links to topics describing the Dataset Designer and tasks that can be accomplished with it.
- Fetching Data into Your Application
Provides links to topics describing how to execute SQL statements and stored procedures, as well as loading the returned data into datasets.
- Displaying Data on Forms in Windows Applications
Provides links to topics describing how to display data on Windows Forms.
- Editing Data in Your Application
Provides links to topics describing how to manipulate the data in the data tables of a dataset.
- Validating Data
Provides links to topics describing how to add validation to a dataset during column and row changes.
- Saving Data
Provides topics about writing data changes back to a database.
- ADO.NET Data Adapters
Provides topics about working with data adapters.
- ADO.NET
Describes the ADO.NET classes, which expose data-access services to the .NET programmer.
- Working with Data in Managed Device Projects
Describes how to manage data for devices in Visual Studio.
- Data in Office Solutions
Contains links to topics that explain how data works in Office solutions, including information about schema-oriented programming, data caching, and server-side data access.