Topic Learn: Create a dataset for .NET Framework application using the Dataset Designer

Question

I wanted to follow this help:

This walkthrough uses SQL Server Express LocalDB and the Northwind sample database.

(All steps followed)

Create a New Windows Forms Application Project

---

(All steps followed)

Add a New Dataset to the Application

---

3. Name the Dataset NorthwindDataset, and then choose Add.

Visual Studio adds a file called NorthwindDataset.xsd to the project and opens it in the Dataset Designer.

OPENS AN EMPTY WINDOW INSTEAD OF THE FILE, with following message:

"Use the Dataset Designer to visiall create and edit datasets.

Drag datebase items from Server Explorer or the Dataset Toolbox onto the design surface,

or right-click here to add new items."

Create a Data Connection in Server Explorer

---

1. On the View menu, click Server Explorer.
2. In Server Explorer, click the Connect to Database button.

Add Connection

Data source:

Microsoft SQL Server Database File (SqlClient)

Database file name (new or existing)

NorthwindDataset

[OK]

The database file 'C:\Users\Mac\Documents\NorthwindDataset.mdf'

does not exist.

Would you like to create it?

[Yes]

Create the Tables in the Dataset

---

This section explains how to add tables to the dataset.

To create the Customers table

---

1. Expand the data connection you created in Server Explorer, and then expand the Tables node.

NO TABLES LISTED!

(PS. How do I find out which tags are available to enter a question?)

Answer 1

This problem has been explained an d solved.

See"What is the difference between "SQL Server Object Explorer" and "Server Explorer"

Answer 2

See"What is the difference between "SQL Server Object Explorer" and "Server Explorer"