: Thanks, I'd stumbled on that (and the AcceptChanges method) but can't work out the syntax for it. I tried:
but get this exception:
Operation must use an updateable query.
I suspect I'm pretty close now; I think I need to define an SQL update query for my datasource and set myOleDBDataAdapter.UpdateCommand = whateveritis
. Does this sound right?
Good God! I was warming to .Net until now. How much code do you need to write to get ONE PIECE of data into a database?
I've dad to set up a DataAdapter and a Connection, fine. Now I need a Dataset, and I need to populate it. OK, the Dataset is effectively a runtime image of the data, I can live with that. Now I have to define a DataTable. I'm sure there's a good reason why this can't be inferred from what is already defined - Not!
Now to actually do something with the data I have to start defining SQL update statements, creating commands, linking the commands to the adapter, creating command parameters, adding these to the commands ... blimey, this is a step forward?
I was expecting something like
myDataTable("myField").value = myForm.myControl.text
Surely the arcane mechanics of physically putting the value into the database is something I should care b*gg*r all about; all I want to do is map the value of a control on my form to a field in the database which I have already described (IMHO] in sufficient detail. I'll live with a "commit" if you insist, but other than that I don't want to get my hands dirty. I stopped doing that two decades ago when 4GL's were invented.
Can anyone point me in the direction of a tool which will handle the mechanics for me? I'm too old and weary to be a labourer these days.