Walkthrough: Creating a DataTable in the Dataset Designer
This walkthrough explains how to create a DataTable (without a TableAdapter) using the Dataset Designer. For information on creating data tables that include TableAdapters, see How to: Create TableAdapters.
Tasks illustrated in this walkthrough include:
Creating a new Windows Application project
Adding a new dataset to the application
Adding a new data table to the dataset
Adding columns to the data table
Setting the primary key for the table
To create a new Windows Application project
From the File menu, create a new project.
Choose a programming language in the Project Types pane.
Click Windows Application in the Templates pane.
Name the project DataTableWalkthrough, and then click OK.
Visual Studio adds the project to Solution Explorer and displays Form1 in the designer.
To add a new dataset item to the project
On the Project menu, click Add New Item.
The Add New Item Dialog Box appears.
In the Templates box, select DataSet.
Visual Studio will add a file called DataSet1.xsd to the project and open it in the Dataset Designer.
To add a new data table to the dataset
Drag a DataTable from the DataSet tab of the Toolbox onto the Dataset Designer.
A table named DataTable1 is added to the dataset.
To create a data table that includes a TableAdapter, see Walkthrough: Creating a TableAdapter with Multiple Queries.
Click the title bar of DataTable1 and rename it Music.
To add columns to the data table
Now that you have created the table, you might want to perform one of the following actions:
Create a form to input data
Add data to the table
View data in a table
Delete a row from a table