Re: Abt Datareader Count

#1

Ray:

Hi. The DataReader has only *forward* readonly capability; and *user*
indexing into the data structure is not yet available...other controls(
dataGrid) can get the record count; but human users cannot...

Derek LaZard

"Ray Cassick (home)" <raycassNOSPAM (AT) adelphia (DOT) net> wrote

Quote:

If I am not mistaken, the dataReader from the V1.1 framework supports a
recordCount property now.

"Jim Blizzard [MSFT]" <jimblizz (AT) online (DOT) microsoft.com> wrote in message
news:3ef4e6a1$1 (AT) news (DOT) microsoft.com...
A DataReader (doesn't matter if it's SQL, OLEDB, ORACLE, ODBC) is
read-only
and forward-only. There's no way to scroll backwards. To get the count
/
length would require passing through the entire set of data and there
would
be no way to get back to the beginning.

You could use a DataSet instead of a DataReader.

Hope this helps.

--
Jim Blizzard
Sr .NET Developer Specialist
Microsoft

Your Potential. Our Passion.

This posting is provided "AS IS" with no warranties, and confers no
rights.
Please reply to newsgroups only. Thanks.

"Anandraj" <a_anandraj_2000 (AT) yahoo (DOT) com> wrote in message
news:u6Zoru9NDHA.704 (AT) tk2msftngp13 (DOT) phx.gbl...
Hi
I am using OELDBDatareader I want to find the number of records in the
Datareader.
I don't find any methods like count and length.
Any Other way is there?

Thanks
Anandraj.A.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Abt Datareader Count

Dotnet FAQs microsoft.public.dotnet.faqs

Re: Abt Datareader Count - 07-08-2003 , 10:35 AM