count(*)

[deeas]

hi
please how i can read the result of : select count(*) command

"SELECT count(*) as [a] FROM devices"

[vekipeki]

Check this: SqlCommand.Exec uteScalar

[Curtis Rutland]

We have two on-site articles (one written by me!)

• How To Use A Database In Your Program
• How To Use A Database In Your Program Part II

Read the second one, I discuss exactly how to use the ExecuteScalar method.

If you don't understand everything, you should read the first one too.

[hajoabdul]

instead of ExecuteReader() try ExecuteScalar() am sure it will work