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 Create and configure 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

  1. From the File menu, create a new project.

  2. Choose a programming language in the Project Types pane.

  3. Click Windows Application in the Templates pane.

  4. 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

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

    The Add New Item Dialog Box appears.

  2. In the Templates box, select DataSet.

  3. Click Add.

    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

  1. Drag a DataTable from the DataSet tab of the Toolbox onto the Dataset Designer.

    A table named DataTable1 is added to the dataset.

    System_CAPS_ICON_note.jpg Note

    To create a data table that includes a TableAdapter, see Walkthrough: Creating a TableAdapter with Multiple Queries.

  2. Click the title bar of DataTable1 and rename it Music.

To add columns to the data table

  1. Right-click the Music table. Point to Add, and then click Column.

  2. Name the column SongID.

  3. In the Properties window, set the DataType property to System.Int16.

  4. Repeat this process and add the following columns:

    SongTitle: System.String

    Artist: System.String

    Genre: System.String

All data tables should have a primary key. A primary key uniquely identifies a specific record in a data table.

To set the primary key of the data table

  • Right-click the SongID column, and then click Set Primary Key.

    A key icon appears next to the SongID column.

To save the DataTableWalkthrough project

  • On the File menu, click Save All.

Now that you have created the table, you might want to perform one of the following actions:

Create a form to input dataWalkthrough: Displaying Data on a Windows Form.
Add data to the tableAdding Data to a DataTable.
View data in a tableViewing Data in a DataTable.
Edit dataDataTable Edits
Delete a row from a tableDataRow Deletion

Connecting to Data in Visual Studio
Preparing Your Application to Receive Data
Fetching Data into Your Application
Bind controls to data in Visual Studio
Editing Data in Your Application
Validating Data
Saving Data
Data Walkthroughs