[ASP.NET] C# 调用存储过程

例1CREATE PROCEDURE p_out @a as int,@b as int,@c as int outputASset @c=@a+@breturn '10'－－－－－－－－－－－－－－－－－－－－－.........SqlCommand cmd2=new SqlCommand("p_out",conn);cmd2.CommandType=CommandType.StoredProcedure;cmd2.Parameters.Add("@a",SqlDbType.Int);cmd2.Parameters.Add("@b",SqlDbType.Int);SqlParameter para_c=cmd2.Parameters.Add("@c",SqlDbType.Int);SqlParameter para_r=cmd2.Parameters.Add("returnvalue",SqlDbType.Int);cmd2.Parameters[0].Value=2;cmd2.Parameters[1].Value=3;para_c.Direction=ParameterDirection.Output;para_r.Direction=ParameterDirection.ReturnValue;conn.open();cmd2.ExecuteNonQuery();conn.close();this.Response.Write(para_c.value.ToString());this.Response.Write(para_r.value.ToString());