Software

Ask something
Discussion Locked

How to Connect VB.net with Access Database

0 helpful
2 replies

by anohewage

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need a sample code to conect access database with vb.net. as well as i need sample code to add records to database, amend records & delete records
please send the code which requried to do given above process

2 replies

by vish.dwi

Here is the simple code. Through this code you can connect VB.net to access database.
Function GetData() As System.Data.DataSet

Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=D:\Tecnical Stu"& _
"dy\Complete_Code\Ch08\data\NorthWind.mdb"
Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString)

Dim queryString As String = "SELECT [Employees].* FROM [Employees]"
Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection

Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter
dataAdapter.SelectCommand = dbCommand
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(dataSet)

Return dataSet
End Function

Good Luck

This discussion is closed to new replies.