something like recordcount?

[phil]

Hi,

Does it exist a function or method like 'recordcount' of the asp 2.0?
Thanks
Phil

 

[Bruno Alexandre]

Yes but you need to use a way to get it

dim dReader as SqlDataReader

command.open()
dReader = command.ExecuteReader()

dReader.VisibleFieldCount() returns an integer with the number of rows

you can read all the fields with

While dReader.read()
name = dReader.Item("columnName")
End While

 

[phil]

Thanks

Yes but you need to use a way to get it

dim dReader as SqlDataReader

command.open()
dReader = command.ExecuteReader()

dReader.VisibleFieldCount() returns an integer with the number of rows

you can read all the fields with

While dReader.read()
name = dReader.Item("columnName")
End While

 

[phil]

Hi Bruno,

I tried dReader.VisibleFieldCount() but this gives the number of fields, not
the number of records (or rows).