home bbs files messages ]

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