OleDbCommand.ExecuteReader() : OdbcCommand « System.Data.Odbc « VB.Net by API

1. VB.Net by API
2. System.Data.Odbc
3. OdbcCommand

OleDbCommand.ExecuteReader()

  


Imports System.Data

Module Test

    Sub Main()
        Dim sConnectionString, sSQL As 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

   
    
  

Related examples in the same category