VB .Net - How to connect Access 2003 Database ( .mdb )

In this tutorial we will share about Visual Basic .Net : How to connect Access 2003 (.mdb) Database Using VB .Net.

Please following below steps :

#1. Create database and table using Office Access
Create Database : DBTM.mdb
Create Table : TBL_PRODUCT
Design TBL_PRODUCT like below picture

Insert sample datain TBL_PRODUCT

Save data

#2. Open and Design Form in Visual Basic .Net
Open your visual basic .Net
Design Form1 like below picture
Add DatagridView in Form1

Save Database DBTM.mdb at folder : Debug

And then, place below code at Form1 VB .Net

Imports System.Data.OleDb
Public Class Form1
    Dim Conn As OleDbConnection
    Dim da As OleDbDataAdapter
    Dim ds As DataSet
    Dim MyDB As String
    Sub ConnectDB()
        MyDB = "provider=microsoft.jet.oledb.4.0;data source=DBTM.mdb"
        Conn = New OleDbConnection(MyDB)
        If Conn.State = ConnectionState.Closed Then Conn.Open()
    End Sub
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        ConnectDB()
        da = New OleDbDataAdapter("Select * from TBL_PRODUCT", Conn)
        ds = New DataSet
        ds.Clear()
        da.Fill(ds, "TBL_PRODUCT")
        DataGridView1.DataSource = (ds.Tables("TBL_PRODUCT"))
    End Sub
End Class

and below for the result

You can click here to download source code tutorial above

Tweet

Related Posts :

VB .Net - How to connect Access 2007 (.accdb)...