Create OleDbConnection to Access database : Access « Database ADO.net « VB.Net Tutorial

Home
VB.Net Tutorial
1.Language Basics
2.Data Type
3.Operator
4.Statements
5.Date Time
6.Class Module
7.Development
8.Collections
9.Generics
10.Attributes
11.Event
12.LINQ
13.Stream File
14.GUI
15.GUI Applications
16.Windows Presentation Foundation
17.2D Graphics
18.I18N Internationlization
19.Reflection
20.Regular Expressions
21.Security
22.Socket Network
23.Thread
24.Windows
25.XML
26.Database ADO.net
27.Design Patterns
VB.Net
VB.Net by API
VB.Net Tutorial » Database ADO.net » Access 
26.1.1.Create OleDbConnection to Access database
Imports System.Data

Module Test

    Sub Main()
        Dim sConnectionString, sSQL As String
        
        'SQL Connection String
      sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\yourdatabase.mdb"

        sSQL = "SELECT Title FROM yourTable"

        Dim conn As New System.Data.OleDb.OleDbConnection(sConnectionString)
        Dim cmd As New System.Data.OleDb.OleDbCommand(sSQL, conn)
        Dim dr As System.Data.OleDb.OleDbDataReader
        conn.Open()

        dr = cmd.ExecuteReader()

        Do While dr.Read()
            System.Console.WriteLine(dr.Item("Title"))
        Loop

        dr.Close()
        conn.Close()
    End Sub
End Module
26.1.Access
26.1.1.Create OleDbConnection to Access database
26.1.2.Connection strings for Sql Server, Access, Oracle, Sybase
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.