Hi

How to check whether there are null rows in a datareader.

here is the query which returns null value.

"select max(attendence) from tblattendance where loginid=34 and att_month='"+december+"'";

but when i check is datareader.hasRows it shows true

when there are no such rows corresponding to month 'december'.

please help me regarding this query.

Thanking you

Issuing select max(attendence) from tblattendance where loginid=34 and att_month='"+december+"'; will return 1 row with a value of NULL for max(attendence) if no records meet your criteria.

Therefore, all you need to do is check if the returned column contains NULL and you'll know that no rows exist.

Cheers
Jeff