Wrox Home  
Search P2P Archive for: Go

  Return to Index  

aspx_professional thread: test if datareader is empty


Message #1 by "John Tyson" <jtyson@t...> on Fri, 6 Dec 2002 12:46:25 -0800
From what I have read, when .Net server gets released. Soon, .Net server is
in RC2 phase.

Best Regards,
Dave

-----Original Message-----
From: John Tyson [mailto:jtyson@t...] 
Sent: Monday, December 09, 2002 8:20 AM
To: ASPX_Professional
Subject: [aspx_professional] Re: test if datareader is empty


Hi James,

When will the new version of the .net framework be released?

Thanks,

John

-----Original Message-----
From: James Yang [mailto:syang11@b...] 
Sent: Saturday, December 07, 2002 8:25 PM
To: ASPX_Professional
Subject: [aspx_professional] Re: test if datareader is empty

There will be a new method in the new .net framework called HasRow(). This
chks to see if there are any rows left

Regards,
 
James Yang
.NET / J2EE Developer
 
----------------------------------------------------------
Email/MSN - hyungsukyang@h...
Yahoo/AIM ID - hyungsukyang
ICQ # - 18268858
----------------------------------------------------------

-----Original Message-----
From: Wim Hollebrandse [mailto:wim@w...] 
Sent: Saturday, December 07, 2002 8:36 AM
To: ASPX_Professional
Subject: [aspx_professional] Re: test if datareader is empty

Simply use the Read method.

if (myReader.Read()) {
    ...
}

Hope that helps,
Wim Hollebrandse
http://www.wimdows.net

----- Original Message -----
From: "Dave Rezoski" <daverezoski@h...>
To: "ASPX_Professional" <aspx_professional@p...>
Sent: Friday, December 06, 2002 8:54 PM
Subject: [aspx_professional] Re: test if datareader is empty


> if you're trying to check the if the reader itself contains no rows,
then
> you actually need to loop through it to determine if there is anything
in
it
> - there is not built in count property, or anything like it.
>
> you can also get the reader and bind it to something like a datagrid,
and
> check the items count in the datagrid.  if it's 0, it's empty.
>
> if you're trying to determine if a particluar field value in the
returned
> reader is null, check isdbnull(fieldname)
>
>
>
>
>
>
> ----Original Message Follows----
> From: "John Tyson" <jtyson@t...>
> Reply-To: "ASPX_Professional" <aspx_professional@p...>
> To: "ASPX_Professional" <aspx_professional@p...>
> Subject: [aspx_professional] test if datareader is empty
> Date: Fri, 6 Dec 2002 12:46:25 -0800
>
> Hi,
>
> How can I test if a datareader is empty?
>
> In general as far as testing for null goes, I've used
>
> If False = Convert.IsDBNull
>
> and
>
> If Not isNothing
>
> But I don't know the syntax for testing whether a datareader returning 
> data from a stored procedure is empty?
>
> Thanks,
>
> John
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to 
> unsubscribe send a blank email to 
>
>
> _________________________________________________________________
> The new MSN 8: smart spam protection and 2 months FREE* 
> http://join.msn.com/?page=features/junkmail
>
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to 
> unsubscribe send a blank email to
>










  Return to Index