Build Your Own ASP.NET 2.0 Web Site Using C# & VB, Second Edition

Creating a New Database Using Visual Web

Developer

Visual Web Developer’s Database Explorer window gives you access to most

database-related features. You can make this window appear by selecting View

> Database Explorer. Right-click the Data Connections node and select Add Con-

nection… from the context menu, as shown in Figure 7.2.

Figure 7.2. Adding a new database connection

If you’ve installed SQL Server using the instructions we stepped through in

Chapter 1, select Microsoft SQL Server from the Choose Data Source dialog that

appears, and click Continue. You’ll then be asked to enter the details for your

data connection. Enter the following data:

❑

Set Server name to localhost\SqlExpress.

❑

Leave the Use Windows Authentication option selected.

❑

Click Test Connection to ensure you can successfully connect to SQL Server

using the data you’ve provided.

❑

Enter Dorknozzle in the Select or enter a database name field. Click OK.

❑

You’ll be asked to confirm the creation of a new database called Dorknozzle.

Click Yes.

255

Creating a New Database Using Visual Web Developer