Additional information: Syntax error (missing operator) in query expression '@Phone No'.
for (int i = 0; i < dataGridView21.Rows.Count; i++) { OleDbCommand command = new OleDbCommand(); command.Connection = connection; command.CommandText = @"insert into Total ([Column1],[Column2],[Column3],[Date],[Receipt No],[Delivery Person],[Report],[Flavours],[Name],[Phone No]) VALUES(@Column1, @Column2, @Column3, @Date, @ReceiptNo, @DeliveryPerson, @Report, @Flavours, @Name , @Phone No)"; //values('" + dataGridView21.Rows[i].Cells[0].Value.ToString() + "','" + dataGridView21.Rows[i].Cells[1].Value.ToString() + "','" + txtDisplay.Text + "','" + label4.Text + "','" + label2.Text + "','" + label128.Text + "'," + dataGridView21.Rows[i].Cells[0].Value.ToString() + ",'" + dataGridView21.Rows[i].Cells[3].Value.ToString() + "','" + dataGridView21.Rows[i].Cells[5].Value.ToString() + "','" + dataGridView21.Rows[i].Cells[6].Value.ToString() + "');"; connection.Open(); for (int j = 0; j < dataGridView21.Rows.Count; j++) { var row = dataGridView21.Rows[j]; if (row.IsNewRow) continue; command.Parameters.Clear(); command.Parameters.AddWithValue("@Column1", row.Cells[0].Value); command.Parameters.AddWithValue("@Column2", row.Cells[1].Value); command.Parameters.AddWithValue("@Column3", txtDisplay.Text); command.Parameters.AddWithValue("@Date", label4.Text); command.Parameters.AddWithValue("@ReceiptNo", label2.Text); command.Parameters.AddWithValue("@DeliveryPerson", label128.Text); command.Parameters.AddWithValue("@Report", row.Cells[0].Value); command.Parameters.AddWithValue("@Flavours", row.Cells[3].Value); command.Parameters.AddWithValue("@Name", row.Cells[5].Value); command.Parameters.AddWithValue("@Phone No", row.Cells[6].Value); command.ExecuteNonQuery(); } connection.Close(); } //printreceiptod(); flpCategories.Enabled = false; flpProducts.Enabled = false; listBox20.Focus(); MessageBox.Show("Inserted Sucessfully", dataGridView21.Rows.Count + " " + "ITEMS", MessageBoxButtons.OK, MessageBoxIcon.Information); listBox20.Focus(); dataGridView21.Rows.Clear(); label128.Text = "Delivery"; while (listBox20.Items.Count > 0) { button64.PerformClick(); } flpCategories.Enabled = true; }
@Report, @Flavors, @Name , @Phone No)"; . . and . command.Parameters.AddWithValue("@Phone No", row.Cells[6].Value);
VALUES(@Column1, @Column2, @Column3, @Date, @ReceiptNo, @DeliveryPerson, @Report, @Flavours, @Name , @Phone No)
VALUES(@Column1, @Column2, @Column3, @Date, @ReceiptNo, @DeliveryPerson, @Report, @Flavours, @Name , \"@Phone No\")
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)