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.
.gif) 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.
|
- 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.
Concepts
Other Resources