Accessing return values(integer ) of stored procedure

Return  2
else
Return  3
GO




public static int myFunction(int Order_ID)

DataAccess ds = new DataAccess();
int ReturnMessage = 0;

try

System.Data.SqlClient.SqlParameter paramRetMsg = new SqlParameter("@ReturnVal", SqlDbType.Int);

/ReturnMessage = Convert.ToInt32 (SqlHelper.ExecuteNonQuery (ds._conStringCCR, CommandType.StoredProcedure, "Test" , paramRetMsg ));

}

catch(SqlException ex)

return ReturnMessage ;