>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.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________