I would like to know if how can I update my database using oledbCommandBuilder
below here is my code:
'save changes made and store it to our database newDataRow = ds.Tables("employeeTable").NewRow() newDataRow.Item(0) = comboPosition.Text newDataRow.Item(1) = txtLastName.Text newDataRow.Item(2) = txtFirstName.Text 'navigateAddRecord(newDataRow, comboPosition, txtLastName, txtFirstName) ds.Tables("employeeTable").Rows.Add(newDataRow) da.SelectCommand = New OleDb.OleDbCommand("select * from employeeTable", con) Dim cb As New OleDb.OleDbCommandBuilder(da) da.Update(ds, "employeeTable") con.Close() Me.Hide() EmployeeRecordsForm.Show()
The error that I get is "Syntax error in INSERT INTO statement." It almost took me 1 day but I cant
configure how it still become error.
below here is the part where the error came from
Thanks in advance for help,