Welcome! and rules
Joel on Software
SqlCommand.ExecuteScalar won't return RETURN?
Currently I have a stored procedure that does X, but all I'm interested right now is having it return different return codes (integers).. so I figure I can use the SQL RETURN method which allows you to return an integer.
I figured it out. What you need to do is still have parameter added to your SqlCommand with the type as return value. Then whatever you did in RETURN will be set to that for you to get the value.
Or simply add the following line as the last statement
Fog Creek Home