How to tell a select returned no records?

  • Thread starter Thread starter Matteo Cima
  • Start date Start date
M

Matteo Cima

Hi
I have a question. I think i've looked almost everywhere...
I need to know if SqlCeDataReader returns records or none... something like
the good ol' DAO's ( .eof AND .bof) or recordcount.

mSql = @"SELECT a, b FROM TBA WHERE a='20'";
System.Data.SqlServerCe.SqlCeDataReader mReader =
dbHandler.Instance.myReader(mSql);

i'd like to have a property that tells me if the SqlCeDataReader is empty or
has records... and how many records.

I managed to evaluate mReader.Read() but something like a real recordcount
would be better...



any ideas?

What am I missing?



10x

Matteo.
 
SqlDataReader.HasRows exists
SqlCeDataReader.HasRows doesn't exist...

unfortunately...

10x
Matteo.
 
Back
Top