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
Populating a DataSet from a DataAdapter (ADO.NET)
Creating Data Applications by Using Visual Studio
Other Resources
Getting Started with Data Access