SQL Server Data Provider : Data Provider « Database ADO.net « VB.Net

1. VB.Net
2. Database ADO.net
3. Data Provider

SQL Server Data Provider

 
Imports System
Imports System.Data
Imports System.Data.OleDb

Module OleDbProvider
   Sub Main()
      ' Set up connection string
      Dim ConnString As String = "provider=sqloledb;" & _
         "data source=(local)\SQLEXPRESS;" & _
         "integrated security=sspi;" & _
         "database=MyDatabase"

      ' Set up query string
      Dim CmdString As String = "SELECT * FROM Employee"

      'Declare Connection and DataReader variables
      Dim Conn As OleDbConnection
      Dim Reader As OleDbDataReader

      Try
         'Open Connection
         Conn = New OleDbConnection(ConnString)
         Conn.Open()

         'Execute Query
         Dim Cmd As New OleDbCommand(CmdString, Conn)
         Reader = Cmd.ExecuteReader()

         'Display output header
         Console.WriteLine("Demonstrates the use " & _
            "of the OleDb Data Provider." & ControlChars.NewLine)
         Console.WriteLine("Querying database {0} with query {1}" & _
            ControlChars.NewLine, Conn.Database, Cmd.CommandText)
         Console.WriteLine("FirstName" & ControlChars.Tab & "LastName")

         'Process The Result Set
         While (Reader.Read())
            Console.WriteLine(Reader("FirstName").PadLeft(9) & _
               ControlChars.Tab & Reader(1))
         End While

      Catch ex As Exception
         Console.WriteLine("Error: {0}", ex)

      Finally
         'Close Connection
         Reader.Close()
         Conn.Close()

      End Try

   End Sub
End Module

           
         
  

Related examples in the same category

1.	OleDb Data Provider
2.	Available ADO.NET Data Providers
3.	Obtain the DbProviderFactory for SQL Server.
4.	Generic Data Access