«

Hi,

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

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

--

Bruno Alexandre
(a Portuguese in Denmark)



"phil" <> escreveu na mensagem
news:...
> Hi,
>
> Does it exist a function or method like 'recordcount' of the asp 2.0?
> Thanks
> Phil
>
>

Thanks

"Bruno Alexandre" <> wrote in message
news:...
> 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
>
> --
>
> Bruno Alexandre
> (a Portuguese in Denmark)
>
>
>
> "phil" <> escreveu na mensagem
> news:...
> > Hi,
> >
> > Does it exist a function or method like 'recordcount' of the asp 2.0?
> > Thanks
> > Phil
> >
> >
>
>

Hi Bruno,

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

"Bruno Alexandre" <> wrote in message
news:...
> 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
>
> --
>
> Bruno Alexandre
> (a Portuguese in Denmark)
>
>
>
> "phil" <> escreveu na mensagem
> news:...
> > Hi,
> >
> > Does it exist a function or method like 'recordcount' of the asp 2.0?
> > Thanks
> > Phil
> >
> >
>
>