如何用SQLParameter,获得存储过程返回的值

[yghuaa]

SqlParameter[] parms={new Sqlparameter("@returnvalue",ParameterDitetion)} 我这样获得不了啊

[xcliang2004]

protected void btnBack_Click(object sender, EventArgs e) { //调用存储过程 string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ToString(); SqlConnection conn = new SqlConnection(conStr); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "NorthwindSearch"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection=conn; conn.Open(); SqlParameter sp = new SqlParameter("@productID", SqlDbType.Int); sp.Value = int.Parse(txtProduct.Text.Trim()); cmd.Parameters.Add(sp); //定义输出参数 sp = new SqlParameter("@outputValue", SqlDbType.NVarChar,50); sp.Direction = ParameterDirection.Output; cmd.Parameters.Add(sp); cmd.ExecuteNonQuery(); txtSupplierID.Text = cmd.Parameters[1].Value.ToString(); conn.Close(); } 存储过程如下: alter procedure NorthwindSearch ( @productID int, @outputValue nvarchar(50) output ) as Select @outputValue=SupplierID from products where ProductID=@productID go

[yghuaa]

引用 1 楼 xcliang2004 的回复:

protected void btnBack_Click(object sender, EventArgs e) { //调用存储过程 string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ToString(); SqlConnection conn = new SqlConnection(conStr); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "NorthwindSearch"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection=conn; conn.Open(); SqlParameter sp = new SqlParameter("@productID", SqlDbType.Int); sp.Value = int.Parse(txtProduct.Text.Trim()); cmd.Parameters.Add(sp); //定义输出参数 sp = new SqlParameter("@outputValue", SqlDbType.NVarChar,50); sp.Direction = ParameterDirection.Output; cmd.Parameters.Add(sp); cmd.ExecuteNonQuery(); txtSupplierID.Text = cmd.Parameters[1].Value.ToString(); conn.Close(); } 存储过程如下: alter procedure NorthwindSearch ( @productID int, @outputValue nvarchar(50) output ) as Select @outputValue=SupplierID from products where ProductID=@productID go

可以定义一个SqlParameter数组，把@productID和@outputValue都存在一起，比如 SqlParameter[] parms={new Sqlparameter("@productID",this.txtproductID.text),new SqlParameter("@outputValue",??)} 到需要存储过程的输出值时就不知道怎么填了

[whqjj2006]

SqlParameter outputparm = new SqlParameter("@returnvalue",SqlDbType.VarChar,64);
          outputparm.Direction = ParameterDirection.IntPutOutput;
          commandpbx.Parameters.Add(outputparm);

使用时：

label.Text=outputparm.Vlaue.ToString();