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.
| >> >
| >> >
| >> >.
| >> >
| >
| >
| >.
| >
|
