I?m having a problem updating my data store.
I successfully added rows to the data set. And all the update commands run
without error until I supply the myAdapter.Update command then I get an
error:
Syntax error in INSERT INTO statement.
Am I missing something?
//generate update command
OleDbCommandBuilder myBuilder = null;
myBuilder = new OleDbCommandBuilder(myAdapter);
myAdapter.UpdateCommand = myBuilder.GetUpdateCommand();
myAdapter.InsertCommand = myBuilder.GetInsertCommand();
myAdapter.DeleteCommand = myBuilder.GetDeleteCommand(); myAdapter.Update
(myDataSet, "Bylines");