Professional IronPython

5.
Click Test Connection. You see a success message box (click OK to dismiss it).
6.
Click OK. Visual Studio displays the new connection in Server Explorer, as shown in 
Figure 17-19.
FIgURE 17-18: 
The Add Connection dialog box
lets you create and test a connection to the
Northwind database.
FIgURE 17-17: 
Select the SQL Server data source to 
make the Northwind connection.
FIgURE 17-19: 
The new connection
appears in Server Explorer where you
can work with it directly.
548592c17.indd 380
2/24/10 12:49:39 PM
www.finebook.ir

---

Using Visual Basic.NET for Database Support
 
❘
 
381
7.
Choose Data
➤➤➪➤➤
Add New Data Source. You’ll see the Data Source Configuration Wizard dia-
log box shown in Figure 17-20.
FIgURE 17-20: 
Use the Data Source Configuration Wizard to create a
coded connection.
8.
Highlight Database and click Next. You’ll see the Choose Database Model page.
9.
Highlight the Dataset option and click Next. You’ll see the Choose Your Data Connection 
page. Notice that the Northwind database connection already appears in the connection 
field. The connection name will have your machine name, followed by the database name, 
followed by .dbo, such as 
main.Northwind.dbo
. If it doesn’t, make sure you select it from 
the list. If the connection doesn’t appear in the list, click Cancel and start over with Step 1 
because your connection wasn’t successful.
10.
Select the Northwind connection and click Next. The wizard will ask how you want to save 
the connection. There isn’t a good reason to change the default name provided.