Employee Table Metadata : SqlDataReader « Database ADO.net « VB.Net

1. VB.Net
2. Database ADO.net
3. SqlDataReader

Employee Table Metadata

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

    Public Class MainClass

        Public Shared Sub Main()
            Using con As New SqlConnection
                con.ConnectionString = "Data Source=.\sqlexpress;Database=AdventureWorks;Integrated Security=SSPI"
                Using com As SqlCommand = con.CreateCommand
                    com.CommandType = CommandType.Text
                    com.CommandText = "SELECT e.BirthDate,c.FirstName,c.LastName FROM HumanResources.Employee e INNER JOIN Person.Contact c ON e.EmployeeID=c.ContactID ORDER BY e.BirthDate;SELECT * FROM HumanResources.Employee"
                    con.Open()
                    Using reader As SqlDataReader = com.ExecuteReader
                        While reader.Read
                            Console.WriteLine("  {0,18:D} - {1} {2}", reader.GetDateTime(0), reader("FirstName"), reader(2))
                        End While
                        If (reader.NextResult()) Then

                            For field As Integer = 0 To reader.FieldCount - 1
                                Console.WriteLine("  Column Name:{0}  Type:{1}", reader.GetName(field), reader.GetDataTypeName(field))
                            Next
                        End If
                    End Using
                    con.Close()
                End Using
            End Using
        End Sub
    End Class

   
    
  

Related examples in the same category

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