Refresh DataTable

  • Thread starter Thread starter MW
  • Start date Start date
M

MW

Hi all

I have a datatable returned from an Oracle Stored Proc containing look up
data. This is used by my application and shared between multiple threads.

The problem is the underlying data for the lookup table gets updated on
irregular intervals externally. What is the best way to refresh this
datatable and have the new rows reflected in my app?
Right now I am repopulating the object at regular intervals by executing the
stored proc. Is there a better way?


TIA
Wazir
 
Hi MW,

No, thats it.
You might change the stored procedure to retrieve only new data (you might
pass it a time of the last change or something like that) though.
 
Many thanks Miha
Just saw that you replied to my query.

Miha Markic said:
Hi MW,

No, thats it.
You might change the stored procedure to retrieve only new data (you might
pass it a time of the last change or something like that) though.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

MW said:
Hi all

I have a datatable returned from an Oracle Stored Proc containing look up
data. This is used by my application and shared between multiple threads.

The problem is the underlying data for the lookup table gets updated on
irregular intervals externally. What is the best way to refresh this
datatable and have the new rows reflected in my app?
Right now I am repopulating the object at regular intervals by executing the
stored proc. Is there a better way?


TIA
Wazir
Click to expand...
Click to expand...
 
Back
Top