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.
-
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.
-
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.
