Export (0) Print
Expand All

TableAdapters 

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.

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.

Related Sections

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.

ASP.NET Data Access (Visual Studio)

Provides links to information on working with data on ASP.NET Web pages.

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.

Community Additions

ADD
Show:
© 2014 Microsoft