1 out of 1 rated this helpful - Rate this topic

TableAdapters

Visual Studio 2010

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.

In This Section

TableAdapter Overview: Explains what TableAdapters are and the tools available to create them.
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.
Working with Null Values in TableAdapters: Provides the steps for enabling null values in TableAdapter parameters.
Walkthrough: Creating a TableAdapter with Multiple Queries: Provides step-by-step instructions for creating a TableAdapter and adding a query to it.

Related Sections

Hierarchical Update: Provides links to topics describing how to save data from related data tables.
TableAdapterManager Overview: Explains what a TableAdapter is and provides descriptions of the TableAdapterManager code that is generated by the Dataset Designer.
Preparing Your Application to Receive Data: Provides links to topics describing the Dataset Designer and tasks that can be accomplished with it.
ADO.NET: Describes the ADO.NET classes, which expose data-access services to the .NET programmer.
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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD