Parag’s Den

Dedicated to my adored friends…..

09- Database

Posted by paragdongre on June 4, 2008


Download a Sample Database from the Microsoft Site

Start this chapter by downloading a sample Database from the Microsoft Site. Enter this URL on your address bar and begin downloading. http://www.microsoft.com/downloads/details.aspx?familyid=C6661372-8DBE-422B-8676-C632D66C529C&displaylang=en . Make sure that you remember where you put the file because you will be specifying the directory later on. Save any previous work you have done on the Visual Basic Application and then create a new project.

Adding a Data Source

The first step in connecting to a database is by identifying the source. Go to the Data Sources tab on the upper right side of the Visual Basic screen and then Add a New Data Source.

 

Select “Database” and then “New Connection…”

Select Data Source and then set it to “Microsoft Access Database File…”

 

The database file name is “Nwind.mdb”. You should know where you saved this *.mdb file when you downloaded it earlier.

Click OK and proceed with adding the data source.

Once you are done, you will see the database for Northwind traders as shown below.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: