asp.net程序里如何得到存储过程的output参数的值!
请详细说明 谢谢
给个列子也可以

SqlCommand cmd = new SqlCommand("hyproc1", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add(new SqlParameter("@sal", SqlDbType.Float));
                cmd.Parameters.Add(new SqlParameter("@Num", SqlDbType.Int));
                cmd.Parameters[0].Value = 110000;
                cmd.Parameters[1].Direction = ParameterDirection.Output;
                cmd.ExecuteNonQuery();
Console.WriteLine(cmd.Parameters[1].Value.ToString());

SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["DBConn"]);
SqlCommand cmdSelect = new SqlCommand("KL_GetInvestCode", conn);
cmdSelect.CommandType = CommandType.StoredProcedure;

SqlParameter sp = cmdSelect.Parameters.Add("@NewCode", SqlDbType.NVarChar, 0,"NewCode";
sp.Direction = ParameterDirection.Output;
try
{
  object a = cmdSelect.ExecuteScalar();
  return cmdSelect.Parameters["@NewCode"].Value.ToString();
}
catch (Exception ex)
{
}
finally
{
        conn.Close();
}

SqlConnection conn = new sqlConnection(conStr);

Sqlcommand cmd = new SqlCommand("存储过程名",conn);

SqlParameter paramOut = cmd.Parameters.Add("@Return_Value","";
paramOut.Direction = ParameterDirection.ReturnValue;

conn.open();
cmd.ExecuteNonQuery();
int i = (int)cmd.Parameters["@Return_Value"].value;

谢谢各位
我回去好好研究一下哈

默认的参数好像是inputouput型的吧？也能后来获取值