Asp.net(C#) 调用存储过程输出参数的值

CREATE PROCEDURE spr_dinid(@din_id int output) AS
select @din_id=(select corp_sprdinid+1 from dbo.info_corp)
if @din_id>0
begin
update dbo.info_corp set corp_sprdinid=corp_sprdinid+1
end

//得到 string dinid值为"@din_id" --------------------编程问答--------------------



            string result=0;

            SqlConnection cn = new SqlConnection("連接字符串");

            SqlCommand cmd = new SqlCommand("spr_dinid",cn);

            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("@din_id", SqlDbType.Int).Direction= ParameterDirection.Output;

            try

            {

                cn.Open();

                cmd.ExecuteNonQuery();

                result = cmd.Parameters["@din_id"].Value.ToString();

            }

            finally

            {

                cn.Close();

                cn.Dispose();

                cmd.Dispose();

            }

--------------------编程问答-------------------- 非常感谢!!测试正确.... --------------------编程问答-------------------- 调用存储过程??我比较喜欢用程序自动生成.这些代码都是千篇一律的.做个小程序生成,即快又准,呵呵 --------------------编程问答-------------------- mark一下

补充：.NET技术 ,  ASP.NET