OleDbDataReader Question

  • Thread starter Thread starter Buddy
  • Start date Start date
B

Buddy

Hello,

How do I get the number of row retrieved on a SELECT
query when using OleDbDataReader?

I am using Framework 1.0.
 
Hello,

I was orginally using the OleDbDataAdapter and then using
the Fill method which provided me with the row count. The
problem is that the DataSet uses DataTable underneath the
cover which is not a lightweight object, we have a
performance issue which is that the GC is constantly been
run due to the Fill command (main cause is the dataset).
We want to use the OleDbDataReader which is light weight
but the only thing we cannot get out of it is the number
of rows. I've noticed through the watch window it holds
the number of rows in a variable called
rowhandleNumberRows but due to it protection level it
cannot be access, this to be means a floor with Microsoft
as they already know the number of rows.
 
use scalar to retreive count
Buddy said:
Hello,

I was orginally using the OleDbDataAdapter and then using
the Fill method which provided me with the row count. The
problem is that the DataSet uses DataTable underneath the
cover which is not a lightweight object, we have a
performance issue which is that the GC is constantly been
run due to the Fill command (main cause is the dataset).
We want to use the OleDbDataReader which is light weight
but the only thing we cannot get out of it is the number
of rows. I've noticed through the watch window it holds
the number of rows in a variable called
rowhandleNumberRows but due to it protection level it
cannot be access, this to be means a floor with Microsoft
as they already know the number of rows.
Click to expand...
 
Hi Budy,

You can visit the link below to get some help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;308352
If you still have any concerns, please feel free to let me know.

Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------
| Content-Class: urn:content-classes:message
| From: "Buddy" <[email protected]>
| Sender: "Buddy" <[email protected]>
| References: <[email protected]>
<ODvWyf#[email protected]>
<[email protected]> <[email protected]>
| Subject: Re: OleDbDataReader Question
| Date: Sat, 16 Aug 2003 23:39:00 -0700
| Lines: 75
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcNkij438AdfHmReR6a8xT2kzl2hcg==
| Newsgroups: microsoft.public.dotnet.languages.csharp
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.csharp:176965
| NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
| X-Tomcat-NG: microsoft.public.dotnet.languages.csharp
|
| I cannot use the ExecuteScalar method for two reasons,
| one that I need all the data back, and second that I
| cannot run the query twice as there are possible INSERT,
| UPDATE, DELETE queries taking place.
|
| Any other ideas?
|
| >-----Original Message-----
| >use scalar to retreive count
| >| >> Hello,
| >>
| >> I was orginally using the OleDbDataAdapter and then
| using
| >> the Fill method which provided me with the row count.
| The
| >> problem is that the DataSet uses DataTable underneath
| the
| >> cover which is not a lightweight object, we have a
| >> performance issue which is that the GC is constantly
| been
| >> run due to the Fill command (main cause is the
| dataset).
| >> We want to use the OleDbDataReader which is light
| weight
| >> but the only thing we cannot get out of it is the
| number
| >> of rows. I've noticed through the watch window it holds
| >> the number of rows in a variable called
| >> rowhandleNumberRows but due to it protection level it
| >> cannot be access, this to be means a floor with
| Microsoft
| >> as they already know the number of rows.
| >>
| >> >-----Original Message-----
| >> >With Framework 1.0 no way to get it (Framework 1.1 has
| >> HasRows property but
| >> >won't tell the row number either) on beforehand.
| Bullet-
| >> proof way is to run
| >> >a separate query that returns the count or use
| DataSet.
| >> >
| >> >For what do you need the count? Perhaps there would be
| >> other approach to
| >> >solve your issue?
| >> >
| >> >--
| >> >Teemu Keiski
| >> >MCP, Designer/Developer
| >> >Mansoft tietotekniikka Oy
| >> >http://www.mansoft.fi
| >> >
| >> >AspInsiders Member, www.aspinsiders.com
| >> >ASP.NET Forums Moderator, www.asp.net
| >> >AspAlliance Columnist, www.aspalliance.com
| >> >
| >> >
| >> >| >> >> Hello,
| >> >>
| >> >> How do I get the number of row retrieved on a SELECT
| >> >> query when using OleDbDataReader?
| >> >>
| >> >> I am using Framework 1.0.
| >> >
| >> >
| >> >.
| >> >
| >
| >
| >.
| >
|
 
Back
Top