Create OleDbConnection to Access database 2 : OleDbConnection « 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 Tutorial » Database ADO.net » OleDbConnection 




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.9.OleDbConnection
26.9.1.Create OleDbConnection to Sql server
26.9.2.Create OleDbConnection to Access database 2
26.9.3.Using sql statement
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.