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

On Jan 30, 6:30 am, "aasif" <immortal_sm...@yahoo.co.uk> wrote:
> 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

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.

--
Tom Shelton

On 30 Jan 2007 05:30:08 -0800, "aasif" <(E-Mail Removed)> wrote:

¤ 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/Sho...27451&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

On 30 Jan, 15:53, "Tom Shelton" <tom_shel...@comcast.net> wrote:
> On Jan 30, 6:30 am, "aasif" <immortal_sm...@yahoo.co.uk> wrote:
>
>
>
> > 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 thanksA 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.
>
> --
> Tom Shelton

On Jan 30, 9:34 am, "aasif" <immortal_sm...@yahoo.co.uk> wrote:
> 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.
>

I'm glad you worked it out.

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

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

--
Tom Shelton