Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

How to: Create a Typed Dataset

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


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


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.


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

Community Additions

© 2015 Microsoft