Hi
I have two forms in my application, Form two has a wingrid and Form one is a data entry page. When a user enters data on form one I wish for this to be reflected on my grid. However it is a multi user application so many users may adding data from different workstations (into the DB), so what is the best solution for this, as potentially people maybe using the grid for stuff, so I do not wish for just an unseemly refresh every 30 seconds or the like. Do you have any ideas on how best to get the grid refreshed without spoiling user experience?
Thanks alot.
dave
Typically the data provider supports some form of notification when records change; for example, for SQLServer, there is a SqlDependency class which notifies the listener when a record has changed. In your case you would listen to an event (such as, in the SqlDependency example, the 'OnChange' event) and refresh the grid's data source when that event fires.
Hi Brian
Thank you for the suggestion, I am using SQL2005 so this looks ideal.
Dave