How can I get the return code from a sql stored proceedure?

[Blitz]

I have a stored proceedure that returns 1,2,3 or 4 depending on what happened in the proceedure. How can i get that return code back to vb.net?

I only know how to get the number of rows affected, i woudl appreciate any help. This is a little snip of the code i have:

cmdParms.Connection = sqlConn
cmdParms.CommandType = CommandType.StoredProcedure
cmdParms.CommandText = strSPName

introwsaffected = cmdParms.ExecuteNonQuery

sqlConn.Close()
Return introwsaffected


What needs to be added to get the return code?

 

[stsuing]

I would add an output paramater to your command object and then set it the very last thing in the sp

cmdParms.Parameters.Add("@return_value", SqlDbType.int)
cmdParms.Parameters("@return_value&quot.Direction = ParameterDirection.Output


in the sp
@return_value int output

at the end of the sp
set @return_value = value

to get the value in vb.net project
cint(cmdParms.Parameters("@return_value&quot.value)

Hope this helps

 

[Blitz]

Thank you that will work.

 

[theoxyde]

ExecuteScalar is another method which can return a single value from the database.