Click here to Skip to main content
15,908,444 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Posted

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);
 
Share this answer
 
v4
I did not find in your code the dwclaration of parameter desc like

C#
string DescValue;
SqlParameter.AddWithValue("@Desc",DescValue);
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900