Find size of GetString in DataReader (vb.net)

[Lee Walters]

Hi All

I'm doing a 'select * from table' in my DataReader below and populating an
array with the results. Obvisouly I'm only getting the first field from the
results by the use of the GetString(0).

My Question is how do I find out how many elements there are to GetString
without having to know how many fields are in the table?

Thanks
-- Code

Dim List As New ArrayList()
Dim ListCount As Integer = 0
Dim ListReader As SqlDataReader = ListCmd.ExecuteReader()
While ListReader.Read()
List.Insert(ListCount, ListReader.GetString(0))
ListCount = ListCount + 1
End While

--

[Shiva]

Use the property SqlDataReader.FieldCount

"Lee Walters" <Le********@discussions.microsoft.com> wrote in message
news:31**********************************@microsof t.com...
Hi All

I'm doing a 'select * from table' in my DataReader below and populating an
array with the results. Obvisouly I'm only getting the first field from the
results by the use of the GetString(0).

My Question is how do I find out how many elements there are to GetString
without having to know how many fields are in the table?

Thanks
-- Code

Dim List As New ArrayList()
Dim ListCount As Integer = 0
Dim ListReader As SqlDataReader = ListCmd.ExecuteReader()
While ListReader.Read()
List.Insert(ListCount, ListReader.GetString(0))
ListCount = ListCount + 1
End While

--

[Lee Walters]

Thanks Shiva - Jus got back into work and seen your reply. Kind of worked it
out while I was away. Nice and easy one.

Anyway - thanks again.

"Shiva" wrote:

Use the property SqlDataReader.FieldCount

"Lee Walters" <Le********@discussions.microsoft.com> wrote in message
news:31**********************************@microsof t.com...
Hi All

I'm doing a 'select * from table' in my DataReader below and populating an
array with the results. Obvisouly I'm only getting the first field from the
results by the use of the GetString(0).

My Question is how do I find out how many elements there are to GetString
without having to know how many fields are in the table?

Thanks
-- Code

Dim List As New ArrayList()
Dim ListCount As Integer = 0
Dim ListReader As SqlDataReader = ListCmd.ExecuteReader()
While ListReader.Read()
List.Insert(ListCount, ListReader.GetString(0))
ListCount = ListCount + 1
End While

--