How to: Create a Typed Dataset

  • Article

You create a typed DataSet using the Data Source Configuration Wizard or the Dataset Designer.

Note

For information on creating datasets programmatically, see Creating a DataSet (ADO.NET).

Creating Typed Datasets with the Data Source Configuration Wizard or with the Dataset Designer

Note

Changes to the database schema (for example, new tables, new or modified columns) are not automatically reflected in existing typed datasets. Edit the dataset using the Data Source Configuration Wizard to update the existing dataset.

To create a dataset with the Data Source Configuration Wizard

  1. On the Data menu, click Add New Data Source to start the Data Source Configuration Wizard.

  2. Select Database on the Choose a Data Source Type page.

  3. Complete the wizard and a typed dataset is added to your project. For more information, see Data Source Configuration Wizard.

To create a dataset with the Dataset Designer

  1. On the Project menu, click Add New Item.

  2. Select DataSet from the Add New Item dialog box.

  3. Type a name for the dataset.

  4. Click Add.

    The dataset is added to the project and opens in the Dataset Designer.

  5. Drag items from the DataSet tab of the Toolbox onto the designer. For more information, see How to: Edit a Dataset.

    -or-

    Drag items from an active connection in Server Explorer/Database Explorer onto the Dataset Designer.

See Also

Tasks

Walkthrough: Connecting to Data in a Database

How to: Edit a Dataset

Concepts

Creating Data Applications by Using Visual Studio

Dataset Designer

Datasets in Visual Studio Overview

Other Resources

TableAdapters

Relationships in Datasets

Preparing Your Application to Receive Data

Connecting to Data in Visual Studio

Fetching Data into Your Application