Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.lang.visual.basic    |    MS Visual Basic discussions, NOT dot-net    |    10,840 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 10,781 of 10,840    |
|    Mike H to All    |
|    Saving records in VB.Net    |
|    24 Jun 09 03:48:47    |
      From: mike_hen@bigpond.net.au              I am having problems saving modified/new records back to an access database       at runtime in VB.NET. I can read the records without problems by opening a       connection and using the Fill command in a DataAdapter but when attempting       to use the Update command of the DataAdapter to write the records back to       the database I get a "Update requires a valid Update command when pass a       Datarow collection with modified rows".              The process I am using is as follows:-              1. Open the connection       2. Create a DataAdapter and use the Fill command to read the original       database rows into a Dataset       3. Apply the changes to these rows adding new rows where necessary to the       Datatable       4. Apply the DataAdapter Update command with the DataTable as an argument.              In reading the Microsoft documentation they infer that this DataAdapter       Update operation is all required to write all new and modified rows back to       the database.              Thanks for any help given in solving this problem.              Mike H              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca