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.
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.
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:
Create a new TableAdapter, the mechanism for communicating between your application and a database
Edit a TableAdapter
Add a query to a TableAdapter
Edit a query in a TableAdapter
Create a new table to store in-memory data
Edit a table to store in-memory data
Add validation code for when column or row values change
Extend the functionality of the dataset by adding more properties, methods, and so on
Enable hierarchical update by using the TableAdapterManager
Separate the generated DataSet and TableAdapter classes into separate projects