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.


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.

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.

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.

Community Additions