526互联

C#获取存储过程的Return返回值和Output输出参数值

发布时间 2023-07-13 17:05:50作者: tyxajh

1、获取Return返回值

复制代码
1 create procedure mySql
2 @a int,
3 @b int
4 as
5    return @a+@b
6 go
复制代码
复制代码
 1 SqlConnection conn=new SqlConnection(ConfigurationManager.ConnectioniString["localServer"].ToString());
 2 conn.Open();
 3 SqlCommand cmd=new SqlCommand("mySql",conn);
 4 cmd.CommandType=CommandType.StoredProcedure;
 5 cmd.Parameters.Add(new SqlParameter("@a",SqlDbType.Int));
 6 cmd.Parameters.Add(new SqlParameter("@b",SqlDbType.Int));
 7 cmd.Parameter["@a"].Value=10;
 8 cmd.Parameter["@b"].Value=20;
 9 cmd.Parameters.Add(new SqlParameter("@return",SqlDbType.Int));
10 cmd.Parameters["@return"].Direction=ParameterDirection.ReturnValue;
11 cmd.ExecuteNonQuery();
12 Response.Write(cmd.Parameters["@return"].Value.ToString());
复制代码

2、获取OutPut输出参数值

复制代码
1 create procedure mySql
2      @a int,
3      @b int,
4      @c int output
5 AS
6      Set @c = @a + @b
7 GO
复制代码
复制代码
 1 SqlConnection conn=new SqlConnection(ConfigurationManager.ConnectioniString["localServer"].ToString());
 2 conn.Open();
 3 SqlCommand cmd=new SqlCommand("mySql",conn);
 4 cmd.CommandType=CommandType.StoredProcedure;
 5 cmd.Parameters.Add(new SqlParameter("@a",SqlDbType.Int));
 6 cmd.Parameters.Add(new SqlParameter("@b",SqlDbType.Int));
 7 cmd.Parameter["@a"].Value=10;
 8 cmd.Parameter["@b"].Value=20;
 9 cmd.Parameters.Add(new SqlParameter("@c",SqlDbType.Int));
10 cmd.Parameters["@c"].Direction=ParameterDirection.Output;
11 cmd.ExecuteNonQuery();
12 Response.Write(cmd.Parameters["@c"].Value.ToString());
复制代码