Hi I have a typed datatable filled from sql server, bound to 2 gridviews
I need to loop through each row every 5 mins and check if price has changed, if so update it. (the price is coming from an external server)
I did have this on a timer and then loop through each row on same thread but was freezing the UI well it was looping, so now have a background worker to check and update.
the only way i seem to be able to get it to work is to clone the table then loop through rows then on background work completed fill the table again. There must be another way.
If I dont clone the table first the ui freezes and does not recover. Please help.