checking if no record is returned

hi,

I basically want the .net version of rs.eof
does anyone know what the code would be using the execute scalar method?

Thanks>>does anyone know what the code would be using the execute scalar method?

executeScalar returns only one record. so theres no such thing as EOF. you are prbly talking of datareader...you just loop through the datareader using

while dr.read()
 ...
end while

if you want more info, you need to give us more details on what xactly it is that you are trying to do.

hth|||or,

if(dr.HasRows)
{
 while(dr.read())
 {
 // Read some stuff
 }
}
else
{
 // no results were found
}