Use SqlDataReader.Read to read result set

 
Imports System
Imports System.Data
Imports System.Data.SqlClient


public class MainClass
   Shared Sub Main()
      Dim thisConnection As New SqlConnection("server=(local)\SQLEXPRESS;" & _
          "integrated security=sspi;database=MyDatabase")

      Dim thisCommand As New SqlCommand _
         ("SELECT FirstName FROM Employee", _
          thisConnection)

      Try
         ' Open Connection
         thisConnection.Open()
         Console.WriteLine("Connection Opened")

         ' Execute Query
         Dim thisReader As SqlDataReader = thisCommand.ExecuteReader()

         While (thisReader.Read())
            Console.WriteLine("Name: {0}", _
               thisReader(0))
         End While

         'Close DataReader
         thisReader.Close()


      Catch ex As SqlException
         ' Display error
         Console.WriteLine("Error: " & ex.ToString())
      Finally
         ' Close Connection
         thisConnection.Close()
         Console.WriteLine("Connection Closed")

      End Try
   End Sub
End Class

Related examples in the same category

1.	From SqlDataReader get Column Name
2.	Format data when reading the data from SqlDataReader
3.	Get number of columns in SqlDataReader
4.	Get info about each column: Name, Ordinal and FieldType
5.	Get data from SqlDataReader by Data type
6.	Use column name to index data
7.	Employee Table Metadata

Use SqlDataReader.Read to read result set : SqlDataReader « Database ADO.net « VB.Net

Related examples in the same category