- Step 1: Create New Project use VB 2008
- Step 2 :Create database and table in MS Access 2003
- Step 3 : Design form in VB .Net 2008
Make sure you already install VB 2008 in your computer
Click Start in your windows
All Programs
Choose Microsoft Visual Studio 2008
Click File - New - Project
Click OK
After that, please follow STEP 2
#Step 2 :
Create Database use MS Access 2003
Database name : db.mdb
Table name : TBL_PRODUCT
design table like below picture :
fill sample product
Save db.mdb at : D:\MyApp\MyApp\MyApp\bin\Debug
#Step 3 :
Design form1 like below picture
Just add "Datagridview1" in Form1
Fill below code at Form1
Imports System.Data.OleDbHere the result :
Public Class Form1
Dim Conn As OleDbConnection
Dim da As OleDbDataAdapter
Dim ds As DataSet
Dim DBLocation As String
Sub DBConn()
DBLocation = "provider=microsoft.jet.oledb.4.0;data source=DB.mdb"
Conn = New OleDbConnection(DBLocation)
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
DBConn()
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
Please click here to download project / source code above