Arokia玛丽:Naerling

必须声明标值@说明: 您好

能否请你纠正我，我要去的地方错了
我给我codebelow，插入的细节，在网格视图
获取错误"必须声明标值@ DESC"

 

protected void lnkInsert_Click(object sender, EventArgs e)

    {

        DeliveryOrder itemDo = new DeliveryOrder();        

        string connectionString = ConfigurationManager.ConnectionStrings["InvoiceConnectionString"].ConnectionString;

        SqlConnection conn = new SqlConnection(connectionString);

        string insertcmd = "insert into Items (Description,ItemNo,Qty,DoNumber)VALUES(@desc,@qty,@itemNo,@doNumber)";

        string itemcmd = "insert into ItemParent(DoNumber,DoDate,CusId,Notes)VALUES(@doNumber,doDate,cusId,notes)";

        SqlCommand cmd = new SqlCommand(insertcmd,conn);

        SqlCommand cmd1 = new SqlCommand (itemcmd,conn);

        conn.Open();

        cmd.Parameters.AddWithValue("@Description", itemDo.Description);

        cmd.Parameters.AddWithValue("@Qty", itemDo.Qty);

        cmd.Parameters.AddWithValue("@ItemNo", itemDo.ItemNo);

        cmd.Parameters.AddWithValue("@DoNumber",itemDo.Donumber);

 

        cmd1.Parameters.AddWithValue("@DoNumber", itemDo.Donumber);

        cmd1.Parameters.AddWithValue("@DoDate", itemDo.DoDate);

        cmd1.Parameters.AddWithValue("@CusId",itemDo.Cusid);

        cmd1.Parameters.AddWithValue("@Notes",itemDo.Notes);

        cmd.ExecuteNonQuery();

        cmd1.ExecuteNonQuery();

        conn.Close();

        lblMessage.Visible = true;

        BindGridView();

 

    }

 

Thanks