ADO.NET Data Adapters

The following topics provide information about ADO.NET data-adapter objects and how to work with them. Adapters are used to exchange data between a data source and a dataset.

Note

In the previous version of Visual Studio, data adapters were used for communicating between an application and a database. While data adapters are still a main component of .NET Framework Data Providers (ADO.NET), TableAdapters are designer-generated components that simplify the process of moving data between your application and a database. For more information on working with TableAdapters, see TableAdapter Overview.

In This Section

• Introduction to Data Adapters
  Provides an overview of what data adapters are, what they are used for, and how they are structured.

• Parameters in Data-Adapter Commands
  Describes the structure and use of parameters that adapters pass at run time to SQL statements or stored procedures.

• Table Mapping in Data Adapters
  Describes options for how to map column names between a source table and a dataset table.

• Creating Data Adapters
  Lists different ways of creating data adapters in Visual Studio.

• How to: Configure Parameters for Data Adapters
  Explains how to create and set properties of parameters that will be passed at run time to data-adapter commands.

• How to: Map Data-Source Columns to Dataset Data-Table Columns
  Provides instructions for how to establish and modify the mapping between the column names of source tables and dataset tables.

• How to: Preview Data-Adapter Results
  Provides instructions for testing how a data adapter will populate a dataset.

Related Sections

• Creating Data Applications by Using Visual Studio
  Provides a general introduction to the concepts of data access in Visual Studio.

• Datasets in Visual Studio Overview
  Provides background information on the structure and use of datasets.

• Populating a DataSet from a DataAdapter (ADO.NET)
  Presents a series of specific example code topics for filling datasets with data adapters.

• 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 TableAdapter Queries
  Provides the steps to add a query to an existing TableAdapter.

See Also

Concepts

What's New in Data

Populating a DataSet from a DataAdapter (ADO.NET)

What's New in Data

Creating Data Applications by Using Visual Studio

Other Resources

Data Walkthroughs

Getting Started with Data Access

DataAdapters and DataReaders (ADO.NET)

Creating Data Adapters

Data Walkthroughs

ADO.NET