View Single Post
  #2 (permalink)  
Old February 26th, 2006, 08:28 PM
adam_kahtava adam_kahtava is offline
Wrox Technical Editor
 
Join Date: Dec 2005
Location: , , Canada.
Posts: 271
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Just as you have your SQL SELECT statement, you must also have an SQL UPDATE statement.
Your OleDbDataAdapter has a SelectCommand set through the OleDbDataAdapter(strSQL, cnx) constructor; however you don't have a corresponding UpdateCommand assigned.

You'll need something like:

sda.UpdateCommand = new OleDbCommand("UPDATE something SET something = @Something WHERE something = something", conn)

More info on the OleDbDataAdapter.UpdateCommand Property:
http://msdn.microsoft.com/library/de...mmandtopic.asp

- A.Kahtava