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