• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 924
  • Last Modified:

count of items or colums of a SQL query using data reader

Greetings,

I need to count the number of colums in a result of a sql query that uses datareader to read the results:
here is the vb code:

 Dim conn As New SqlConnection(connectionString)
        Dim command As New SqlCommand(strVFD_MO, conn)
        command.CommandType = CommandType.Text

        conn.Open()
        Dim reader As SqlDataReader = command.ExecuteReader()
        Dim i As Integer = 0
        If reader.HasRows Then
            Do While reader.Read()
' the number of colums is unknown, so item id such as reader(0) should not be hard coded
                Debug.WriteLine(reader(0), reader(1))
            Loop
        End If

thanks!!
0
exquisite_uae
Asked:
exquisite_uae
  • 3
1 Solution
 
Pratima PharandeCommented:

 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 number of columns
         Console.WriteLine()
         Console.WriteLine("Number of columns in a row: {0}", _
            thisReader.FieldCount)
 
 
         'Close DataReader
         thisReader.Close()
 
      

Open in new window

0
 
Pratima PharandeCommented:
Use  thisReader.FieldCount
0
 
Pratima PharandeCommented:
FieldCount - returns the number of columns in the result set.
GetFieldType(int) - returns the Type of the column.
GetDataTypeName(int) - returns the Name of the back-end database column
type.
GetName(int) - returns the Column Name.
0
 
exquisite_uaeAuthor Commented:
thanks..thats exactly what i need :)
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now