VB.NET

connecting to a dataabase in vb.net

Please support our VB.NET advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Nov 2007

Posts: 2

Reputation: tau is an unknown quantity at this point

Solved Threads: 0

tau

Offline

Newbie Poster

connecting to a dataabase in vb.net

Dec 12th, 2007

hi there i m having problems how do i connect to database in vb.net

•

Join Date: Nov 2007

Posts: 2,641

Reputation: Jx_Man is a glorious beacon of light

Solved Threads: 245

Jx_Man

Offline

Posting Maven

Re: connecting to a dataabase in vb.net

Dec 12th, 2007

specify database that u want to use. sql server, access, mysql, oracle, etc..

•

Join Date: Nov 2007

Posts: 2

Reputation: tau is an unknown quantity at this point

Solved Threads: 0

tau

Offline

Newbie Poster

Re: connecting to a dataabase in vb.net

Dec 13th, 2007

how do i connect to0 an access database in vb.net

•

Join Date: Nov 2007

Posts: 2,641

Reputation: Jx_Man is a glorious beacon of light

Solved Threads: 245

Jx_Man

Offline

Posting Maven

Re: connecting to a dataabase in vb.net

Dec 13th, 2007

try this :
first you must made module to connect access to vb.net
add this following code in your module connected :

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
Module MyModule
    Public Function Conection() As OleDb.OleDbConnection
        Dim con As OleDb.OleDbConnection
        con = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath.ToString & "\yourDatabaseName.mdb")
        Return con
        con = Nothing
    End Function
 End Module
Module MyModule
    Public Function Conection() As OleDb.OleDbConnection
        Dim con As OleDb.OleDbConnection
        con = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath.ToString & "\yourDatabaseName.mdb")
        Return con
        con = Nothing
    End Function
 End Module

after that you can call this module in your form code to connect with access db
ex :
Dim Connected = MyModule.Koneksi

then u can open connection (Connected .Open()) or close connection (Connected.close())

OK.
Hope this code helpfull

Last edited by Jx_Man; Dec 13th, 2007 at 5:03 am.