参数化查询 '(@p1 char(8000),@p2 char(8000),@p3 char(8000),@p4 char(8000),@p5' 需要参数...

Question

参数化查询 '(@p1 char(8000),@p2 char(8000),@p3 char(8000),@p4 char(8000),@p5' 需要参数 '@p1'，但未提供该参数,具体代码如下：
protected void Button3_Click(object sender, EventArgs e)
        {
            //以下代码是连接到一个叫“Goods”的表从而对用户输入的Id进行查询
            String s = "Data Source = win-9kv8nfp44mo;Initial Catalog = test.db;Integrated Security = true";
            SqlConnection connection = new SqlConnection(s);
            SqlCommand cmd = connection.CreateCommand();
            connection.Open();
            cmd.CommandText = "SELECT Goods_Id, Goods_Name,Goods_Num FROM Goods";            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(adapter);
            adapter.InsertCommand = cmdBuilder.GetInsertCommand();
            adapter.DeleteCommand = cmdBuilder.GetDeleteCommand();
            adapter.UpdateCommand = cmdBuilder.GetUpdateCommand();            adapter.Fill(ds);
            DataTable dt = ds.Tables["Table"];            //dt.Rows.Add(new object[] { "011", "banana", 50 });   //
            //adapter.Update(ds);                                  //这两行我添加数据的时候可以添加的
            int flag = 0;
            if (this.TextBox2.Text == "" || this.TextBox3.Text == "")
            {
                this.Label4.Text = "请完成以上信息后确认预订";
            }
            else
            {
                foreach (DataRow row in dt.Rows)
                {
                    string bb = row["Goods_Id"].ToString().Trim();
                    if (bb.Equals(this.TextBox2.Text))
                    {
                        flag = 1;
                        int cc = int.Parse(row["Goods_Num"].ToString()) - Int32.Parse(this.TextBox3.Text);
                        this.Label4.Text = "预订成功，管理员会尽快处理您的预订要求，预订后产品还剩" + cc;                        //以下部分是将用户提交的订单信息传递到一个“预订”数据表
                        SqlCommand cmd1 = connection.CreateCommand();
                        //connection.Open();         这里说数据库已经打开无需再打开
                        cmd1.CommandText = "SELECT Custom_Name, Good_Id, Num FROM 预订";
                        SqlDataAdapter adapter1 = new SqlDataAdapter(cmd1);
                        DataSet ds1 = new DataSet();
                        SqlCommandBuilder cmdBuilder1 = new SqlCommandBuilder(adapter);
                        adapter1.InsertCommand = cmdBuilder1.GetInsertCommand();
                        adapter1.DeleteCommand = cmdBuilder1.GetDeleteCommand();
                        adapter1.UpdateCommand = cmdBuilder1.GetUpdateCommand();
                        
                        adapter1.Fill(ds1);
                        DataTable dt1 = ds1.Tables["Table"];
                        //dt1.Rows.Add(new object[]{this.TextBox4.Text.ToCharArray(), this.TextBox2.Text.ToCharArray(), Int32.Parse(this.TextBox3.Text)});
                        dt1.Rows.Add(new object[]{"test2_name","test2_id",0});
                        adapter1.Update(ds1);     //就在这行报错，如最上面所写的
                        //dt1.AcceptChanges();                        //dt.Rows.RemoveAt(this.);
                        //row.Delete();
                        return;
                    }
                }
                if (flag == 0)
                    this.Label4.Text = "您输入的产品编号有误，请确认后重新输入";
            }
            
        }

Answer 1

如果你的sql语句或存储过程中有参数，你需要添加参数才行，比如        SqlCommand command = new SqlCommand(commandText, connection);
        command.Parameters.Add("@ID", SqlDbType.Int);
        command.Parameters["@ID"].Value = customerID;

Answer 2

简单点就是adapter1.Update(ds1);这行报错，报错内容：参数化查询 '(@p1 char(8000),@p2 char(8000),@p3 char(8000),@p4 char(8000),@p5' 需要参数 '@p1'，但未提供该参数,

Answer 3

谢了，确实是参数的问题，但是是我定义了两个adapter后搞混了，谢了