VB.NET

VB.NET RSS

I need help for connecting to Ms access database

Please support our VB.NET advertiser: Intel Parallel Studio Home

•

Join Date: Jun 2008

Posts: 117

Reputation: kavithabhaskar is an unknown quantity at this point

Solved Threads: 0

kavithabhaskar kavithabhaskar is offline

Offline

Junior Poster

Re: I need help for connecting to Ms access database

#11

Jun 17th, 2008

Hi SethR:

I am Kavitha and I am a newbie to VB.NET. I want to know as to what this code would do!. Can you just explain it to me?

Thanks,
Kavitha.

•

Originally Posted by SethR

try something like this......

Private currpath As String = System.Environment.CurrentDirectory
Private connService As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source= " & currpath & "\ServiceCalls.mdb")
Public daCustomers As New System.Data.OleDb.OleDbDataAdapter("Select * from Customers", connService)
Public daCalls As New System.Data.OleDb.OleDbDataAdapter("Select * from Calls ORDER BY CustomerID", connService)
Private daCallStatus As New System.Data.OleDb.OleDbDataAdapter("Select * from Status", connService)
Private cbCustomers As New System.Data.OleDb.OleDbCommandBuilder(daCustomers)
Private cbCalls As New System.Data.OleDb.OleDb