Wrox Home  
Search P2P Archive for: Go

  Return to Index  

aspx_beginners thread: myAdapter.Update


Message #1 by Cindy.Somerville@h... on Thu, 15 Aug 2002 17:06:50
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");

  Return to Index