Data not updated until restart

**thek** · 07-08-2009 8:22 AM

Originally Posted by jmcilhinney

If you're loading the data in your Load event handler and you want to be able to load the data elsewhere too then just take the code out of the Load event handler and put it into a method that you can call from anywhere.

Then the records are duplicated, in the GUI (e.g they are there twice)

**MattP** · 07-08-2009 10:52 AM

Originally Posted by thek

Then the records are duplicated, in the GUI (e.g they are there twice)

Only if you've set the TableAdapter's ClearBeforeFill property to False.

TableAdapter Overview

**thek** · 07-08-2009 12:37 PM

You're on to something, but ClearBeforeFill is not a member of System.Data.OleDb.OleDbDataAdapter

**JohnH** · 07-08-2009 2:16 PM

ClearBeforeFill is a property of a strongly typed data adapter, ie a TableAdapter, which causes the code to call dataTable.Clear before each filling.

I agree with the others here that you're taking the wrong approach to learn data access, the easier beginner start is to use the Visual Studio wizards. You know you can read the code it generates afterwards, if you wish to see 'how it's done in code' ?

**thek** · 07-09-2009 2:38 PM

I agree with the others here that you're taking the wrong approach to learn data access, the easier beginner start is to use the Visual Studio wizards.

Hi guys

I agree. I'll create a new tread to taking it from the start

Thanks for your help (all of you)

Kind regards,
thek

Thread: Data not updated until restart

LinkBack

Thread Tools

Display

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions