C#获取存储过程的Return返回值和Output输出参数值
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());
