Return value from a Stored Procedure

SqlParameter paramReturnValue = new SqlParameter();
 paramReturnValue.ParameterName = "@RETURN";
 paramReturnValue.Direction = ParameterDirection.Output;

 ...

 conn.Open();
 cmd.Connection = conn;
 cmd.ExecuteNonQuery();

 ...

 int returnValue = (int)cmd.Parameters["@RETURN"].Value;