I'm trying to insert data into a database with an autonumber in MS Access as primary key. I get an error saying "Number of query values and destination fields are not the same. Here's my code:
Code:For Each row As DataGridViewRow In DataGridView1.Rows Dim connString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Daily Inventory.accdb;" Using conn As New OleDbConnection(connString) Using cmd As New OleDbCommand("Insert into Table1 Values(@OrderNo, @Product, @Qty, @Price, @TDate)", conn) cmd.Parameters.AddWithValue("@OrderNo", TxtOrder.Text.ToString) cmd.Parameters.AddWithValue("@Product", row.Cells("Product").Value) cmd.Parameters.AddWithValue("@Qty", row.Cells("Qty").Value) cmd.Parameters.AddWithValue("@Price", row.Cells("Price").Value) cmd.Parameters.AddWithValue("@TDate", Date.Now.ToString("MM/dd/yyyy")) If conn.State = ConnectionState.Open Then conn.Close() End If conn.Open() cmd.ExecuteNonQuery() conn.Close() End Using End Using Next




Reply With Quote
