例1
CREATE PROCEDURE p_out
@a as int,
@b as int,
@c as int output
AS
set @c=@a+@b
return '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());
[ASP.NET] C# 调用存储过程
最新推荐文章于 2013-09-11 22:21:00 发布