CREATE PROCEDURE k_kk (@a varchar,@b varchar output)
AS
select * from biao where a=@a
select @b='c'
GO
SqlConnection con=new SqlConnection("data source=fds;uid=sa;pwd=ddda;initial catalog=hsb");
con.Open();
SqlCommand scd=new SqlCommand ("k_kk",con);
scd.CommandType=CommandType.StoredProcedure;
scd.Parameters.Add("@a",SqlDbType.VarChar);
scd.Parameters["@a"].Value="3";
scd.Parameters.Add("@b",SqlDbType.VarChar);
scd.Parameters["@b"].Direction=ParameterDirection.Output;
scd.ExecuteNonQuery();
this.label1.Text=scd.Parameters["@b"].Value.ToString();
//储存过程里设置了OUTPUT,为什么取不到呢,是哪里错了啊。
AS
select * from biao where a=@a
select @b='c'
GO
SqlConnection con=new SqlConnection("data source=fds;uid=sa;pwd=ddda;initial catalog=hsb");
con.Open();
SqlCommand scd=new SqlCommand ("k_kk",con);
scd.CommandType=CommandType.StoredProcedure;
scd.Parameters.Add("@a",SqlDbType.VarChar);
scd.Parameters["@a"].Value="3";
scd.Parameters.Add("@b",SqlDbType.VarChar);
scd.Parameters["@b"].Direction=ParameterDirection.Output;
scd.ExecuteNonQuery();
this.label1.Text=scd.Parameters["@b"].Value.ToString();
//储存过程里设置了OUTPUT,为什么取不到呢,是哪里错了啊。
SqlConnection con=new SqlConnection("data source=fds;uid=sa;pwd=ddda;initial catalog=hsb");
con.Open();
SqlCommand scd=new SqlCommand ("k_kk",con);
scd.CommandType=CommandType.StoredProcedure;
scd.Parameters.Add("@a",SqlDbType.VarChar,20);//加大小
scd.Parameters["@a"].Value="3";
scd.Parameters.Add("@b",SqlDbType.VarChar,20);//加大小
scd.Parameters["@b"].Direction=ParameterDirection.Output;
scd.ExecuteNonQuery();
this.label1.Text=scd.Parameters["@b"].Value.ToString();
select @b='c'
怀疑第一句就返回了