This documentation is archived and is not being maintained.

Creating Data Adapters

Data adapters define the means by which you can get information from one or more tables in the data source into a dataset and back again. For an overview, see Introduction to Data Adapters.

In Visual Studio there are a number of ways you can create and configure data adapters: using Server Explorer, a wizard, "manually" (configuring it with the Properties window), and in code. The topics listed below provide information on each method.

In This Section

Creating Data Adapters Using Server Explorer
Explains how you can drag database elements onto a form or component and generate the adapter automatically.
Creating Data Adapters Using a Wizard
Explains how the Data Adapter Configuration Wizard prompts you for all the information required to configure the data adapter (including parameters) and, if necessary, create a connection.
Creating and Configuring Data Adapters Manually
Explains how to drag a data adapter from the Toolbox, and then configure it yourself using the Properties window.
Populating a DataSet from a DataAdapter
Explains how to create an instance of an adapter in code and use it to fill a dataset.

Related Sections

Introduction to Data Adapters
Provides an overview of what data adapters are, what they are used for, how they are structured.
Introduction to Data Access with ADO.NET
Provides a general introduction to the concepts of data access in Visual Studio.
Introduction to Datasets
Provides background information on the structure and use of datasets.
Creating and Filling Datasets Example Topics
Presents a series of specific example code topics for common tasks in creating and filling datasets with Visual Basic .NET.
Manipulating Data Example Topics
Presents a series of specific example code topics for common tasks in working with data within your application using Visual Basic .NET.