I have a server with a SQL server database. This database contains our live trades for the day, updated in real time. The size of the table is very small (like a few hundred rows only).
The client machine has a datatable of these trades which loads fine using dataAdapter.Fill. I want the client datatable to be updated in real time.
If I call the fill again it doens't work, and I cannot clear the table, just make changes to it to make sure they are in-sync.
What is the best way to do this over the LAN? Keep in mind I would like this to work as real-time as posssible, however a small delay could be tolerable.
Should i create a second datatable, have it constantly clear and fill on a timer and run code to update one row at a time? or is there an easier way?