>Does the ExecuteScaler work on only select statements? I see what you are only returning one field, so what would happen if you need to fields?
>

It will work with a stored procedure as well.

It only returns a single result field, so no, it will not work with something that returns multiple fields or records.

If you need more fields or rows, then you will need a datareader or other more complex object.