Hello Friends,
I want to know What method should be use to see if there is any row selected in the DataReader or not? Is it DataReader.HasRows, DataReader.Count, or DataReader.Read.



Gaurav Jain

__________________
Gaurav

Dear Gaurav:
DataReader is a readonly object to read the retrevied data from DB & u can not select a row of it,Its not elective u do it in a loop to do something with retrived data.
Could I ask what r u going to do?!

Always:),
Hovik Melkomian.

I want to check if DataReader contains data or not because it may be the case that DataReader may not retrieve any result and contains null value. Doesn't DataReader.HasRows and DataReader.Count exists??

There's a difference between whether the DataReader contains any record at all and if there is a record, whether some of its columns are null or not.

As of .NET 1.1, the data reader has an HasRows property that allows you to check whether any records have been returned, without actually looking at them. Alternatively, you can simply try to read from the reader:

If myReader.Read()
  'records found
End If

Once you have a record, you can use its IsDBNull method to determine whether a column in that record contains a null value or not.

The MSDN documentation for the DataReader provides a lot more information and examples.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

I am using Microsoft Enterprise Library for data access and I am using IDataReader to get the resultset. Since IDataReader doesnot have HasRows property I cannot check weather the reader returns result or not. If I use reader.Read(), it always returns 1 record less. I posted this issue earlier as well and i was suggested to implement HasRows by simply reading reader.Read() and setting the boolean value. But that also returns 1 record less. I am using Repeater control to display the result set.

Is there any other way I can check if the reader has records or not?

Thanks in advance

That's not what we suggested. What we suggested was to keep track of a counter (for example) while reading.

Read() always eats a record. So if you use Read to check if there is a record you loose one. However, like this you won't:

bool hasRecords = false;
while (myReader.read())
{
  //Do whatever you need to do with myReader here
  hasRecords = true;
}

// Here you know whether there are records or not.

Otherwise, like I suggested in my article, check out the data-bound control after data binding.

Why did you move the discussion to this (old) thread? What was wrong with the other discussion?


Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004