Get info about each column: Name, Ordinal and FieldType : SqlDataReader « Database ADO.net « VB.Net

Home
VB.Net
1.2D
2.Application
3.Class
4.Data Structure
5.Data Types
6.Database ADO.net
7.Development
8.Event
9.File Directory
10.Generics
11.GUI
12.Language Basics
13.LINQ
14.Network Remote
15.Security
16.Thread
17.Windows Presentation Foundation
18.Windows System
19.XML
20.XML LINQ
VB.Net Tutorial
VB.Net by API
VB.Net » Database ADO.net » SqlDataReaderScreenshots 
Get info about each column: Name, Ordinal and FieldType
Get info about each column: Name, Ordinal and FieldType
 
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")

      'Sql Query 1
      Dim sql As String ="SELECT  FirstName, LastName FROM Employee;  "

      'Create Command object
      Dim thisCommand As New SqlCommand _
         (sql, thisConnection)

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

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

         ' Get info about each column
         Console.WriteLine("'{0}' has index {1} and type {2}", _
            thisReader.GetName(0), _
            thisReader.GetOrdinal("FirstName"), _
            thisReader.GetFieldType(0))

         '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.Use SqlDataReader.Read to read result setUse SqlDataReader.Read to read result set
2.From SqlDataReader get Column NameFrom SqlDataReader get Column Name
3.Format data when reading the data from SqlDataReaderFormat data when reading the data from SqlDataReader
4.Get number of columns in SqlDataReaderGet number of columns in SqlDataReader
5.Get data from SqlDataReader by Data typeGet data from SqlDataReader by Data type
6.Use column name to index dataUse column name to index data
7.Employee Table Metadata
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.