How to: Edit a Dataset

After creating a typed dataset, you can modify its schema by adding or editing the TableAdapters, data tables, TableAdapter queries, and relationships that make up the dataset using the Dataset Designer. Visual Studio provides wizards (TableAdapter Configuration Wizard and TableAdapter Query Configuration Wizard) to help you work with some of these objects.

For information on creating datasets, see How to: Create a Typed Dataset.

Open the Dataset

To open the dataset for editing

• Double-click your .xsd file to open the dataset. For more information, see How to: Open a Dataset in the Dataset Designer.

Edit the Dataset

To edit the dataset

• Choose an object on the design surface to edit. The following table provides links to topics that explain how to edit the different objects in a dataset:

  To	See
  Create a new TableAdapter, the mechanism for communicating between your application and a database	How to: Create TableAdapters
  Edit a TableAdapter	How to: Edit TableAdapters
  Add a query to a TableAdapter	How to: Create TableAdapter Queries
  Edit a query in a TableAdapter	How to: Edit TableAdapter Queries
  Create a new table to store in-memory data	How to: Create DataTables
  Edit a table to store in-memory data	Designing DataTables
  Add validation code for when column or row values change	Validating Data
  Extend the functionality of the dataset by adding more properties, methods, and so on	How to: Extend the Functionality of a Dataset
  Enable hierarchical update by using the TableAdapterManager	TableAdapterManager Overview
  Separate the generated DataSet and TableAdapter classes into separate projects	How to: Separate Datasets and TableAdapters into Different Projects

See Also

Tasks

Walkthrough: Displaying Data on a Windows Form

How to: Connect to Data in a Database

Reference

Data Sources Window

Concepts

Working with Datasets in Visual Studio

TableAdapter Overview

Dataset Designer

Validating Data

N-Tier Data Applications Overview

Hierarchical Update Overview

Other Resources

Data Walkthroughs