必须声明标量值@Desc [英] Must declare scalar value @Desc

问题描述

嗨
你能纠正我哪里出问题了吗?
我已经给出了下面的代码以在网格视图中插入详细信息
出现错误必须声明标量值@Desc"

Hi
Could you please correct me where i am going wrong
i have given my codebelow to insert the details in grid view
Getting error"Must declare scalar value @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

推荐答案

您的查询具有@desc参数，但是您将参数@Description添加到了参数列表中. 字符串insertcmd =插入项目(描述，项目编号，数量，数量)VALUES( @desc ，@ qty，@ itemNo，@ doNumber)";
//...
cmd.Parameters.AddWithValue("@ Description" ，itemDo.Description);

Your query has the @desc parameter, but you add the parameter @Description to your parameter list.
string insertcmd = "insert into Items (Description,ItemNo,Qty,DoNumber)VALUES(@desc,@qty,@itemNo,@doNumber)";
//...
cmd.Parameters.AddWithValue("@Description", itemDo.Description);

我在您的代码中没有找到像

I did not find in your code the dwclaration of parameter desc like

string DescValue;
SqlParameter.AddWithValue("@Desc",DescValue);

这篇关于必须声明标量值@Desc的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！