Cant get database to update

  • Thread starter Thread starter aasif
  • Start date Start date
A

aasif

Hi all

I have a problem. I update a tablerow, with a new field value, then do
accept changes, but when I restart the app the data is the same

its not that the old data is copied again to the ouput folder as I
actually run from the debug folder, and do not rebuild

Seems the data row changes while the program is running but it doesnt
change the database file, even with acceptchanges() .. any ideas why?

In vb2005 this is

Here is some code : http://rafb.net/p/06uS4t19.html

Any help appreciated thanks
 
Hi all

I have a problem. I update a tablerow, with a new field value, then do
accept changes, but when I restart the app the data is the same

its not that the old data is copied again to the ouput folder as I
actually run from the debug folder, and do not rebuild

Seems the data row changes while the program is running but it doesnt
change the database file, even with acceptchanges() .. any ideas why?

In vb2005 this is

Here is some code :http://rafb.net/p/06uS4t19.html

Any help appreciated thanks
Click to expand...

A dataset is a disconnected set of data. Calling AcceptChanges only
has an affect on the local data. If you want to persist back to the
datasource, then you need to use the Update method of the DataAdapter.
 
¤ Hi all
¤
¤ I have a problem. I update a tablerow, with a new field value, then do
¤ accept changes, but when I restart the app the data is the same
¤
¤ its not that the old data is copied again to the ouput folder as I
¤ actually run from the debug folder, and do not rebuild
¤
¤ Seems the data row changes while the program is running but it doesnt
¤ change the database file, even with acceptchanges() .. any ideas why?
¤
¤ In vb2005 this is
¤
¤ Here is some code : http://rafb.net/p/06uS4t19.html

I would check out the following FAQ:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=427451&SiteID=1


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Thanks for the quick replies, I figured it out after reading the MSDN
help for a while, and realised I hadnt tried the adaptor.update()
method, I did and it worked :) just came here to say its solved.

Sorry for being such a newbie, and many thanks for your replies!

Asif
 
Thanks for the quick replies, I figured it out after reading the MSDN
help for a while, and realised I hadnt tried the adaptor.update()
method, I did and it worked :) just came here to say its solved.
Click to expand...

I'm glad you worked it out.
Sorry for being such a newbie, and many thanks for your replies!
Click to expand...

Don't worry about that... That's what this group is here for!
 
Back
Top