How to tell a select returned no records?

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.
 
M

Matteo Cima

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

unfortunately...

10x
Matteo.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Records aren't being retrieved. 1
need help with max query 2
Query returns no records problem 4
Checking If Recordset Returns Any Rows 4
Struggling with current record 10
SOS...SOS...SOS 2
Deleting Records 4
Return query records in groups of 500 1

Top