I am using the Chapter 20 example in order to link a simple Textbox to table in an Access Database (I have other forms in my program that do this manually, but I just downloaded the book and wanted to try having VS2010 do some of the work instead).
Here are the steps that I did to re-create the example.
1) I added a Dataset Class to my Project and titled it CDInformation
2) I dragged the table CDInfo from my linked Database to the Dataset configuration
3) I dragged the field: CDName from the Dataset onto the Form
When I run the program, the data from the table appears correctly in the form.
However, when I click on the Update button, I get the following error on the line:
Update requires a valid UpdateCommand when passed DataRow collection with modified rows
I'm familiar with the UpdateCommand because I'm using it in another form, however in order to declare the command "builder", I would need to add the line:
Dim builder As OleDbCommandBuilder = New OleDbCommandBuilder(<oledbdataadpatername>)
And I get an error when I try and add this to the program.
I'm sure that I've got some mismatch in my DataSet's definition of the Solution Explorer, but I'm not sure what I'm looking for.
If anyone has any idea, I'd greatly appreciate it.
Thank for your time in advance,
Forceware Systems, Iinc.