SQLCE

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

How can I get the result of a SELECT sqlce command and
know if one or zero rows affected?
 
I think you have a few choices.

Use a Dataset and then ds.Tables["table"].Rows.Count will
have the count.

Execute the same sql command but with select count(column)
first.
 
Look up the SqlCeDataReader class in the help. There is an example in
the About. Basically, your SqlCeCommand select query will return an
SqlCeDataReader object which you will use to iterate through affected
rows. If Zero rows are affected, the read() function returns false
immediately.

Joe Zhang
 
You must log in or register to reply here.

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

Help about choosing efficient database technology 3
Converting table info in sqlce3.5 database to 3.1 2
SQLCE 3.5 and Management Studio 2005 9
XML to SQLce 4
sqlce and compact framework as part of cab file package 6
Updating the SqlCe database from a DataSet 5
.NET CF SQLCE & Chinese characters 4
SqlCe Insert / Replace NText Problem 0

Back
Top