Pages

Friday 29 March 2013

Using MS Access Connecting to VB.NET as Database

How to Use MS Access as Database of VB.NET Program?

Step 1
     Create a Project in Visual Basic.net. Click "File" on the Tab menu and select the "New" and click "Project". On the New Project dialog in the left side you been see the Visual Basic, click the text Visual Basic and under the Visual Basic you been see the "Windows" and on the right side there are many templates selection, select the "Windows Forms Application"

Here is the Sample Image on how to create New Project in Windows Form Application.

You can Change the Name and the location of your project. and the Click the "OK" Button.

The Output of your project is like the image below.

Step 2
          Create new Database in MS Access. Create a table of Employee Information which has an EmployeeID, EmployeeName, Gender, Address, Contact Number as the fields of the Employee Information. Put an Information of the Employee According to its Column name.

        After creating DataBase, Find the location of database, Click the database, hold and Drag the database and Drop into the Solution Explorer Tab where your project name found.

From The Location of your database Drag it into the Project.
After Drop the Database into your project name. You been see like the image below.

You must Select if what database do you want in your dataset. After Select objects, Click the "Finish" Button. And the project is already has a MS Access database. How to use the DataBase connected to your Project? Click Here


No comments:

Post a Comment