When running the application in multiuser environment changes made by one user i.e modifying, adding or deleting records are not seen by other user until they restart the application. I think I know why this problem is occuring. During Form_load, data from the table is collected into a Dataset, which is displayed on form using databinding. When user starts the application data containing in the table is only transferred to Dataset ,so the user cant see changes made by other user during runtime.
Please help on this issue.
Thanks in Advance.
UPDATE
somehow I have handled concurrency issue, but still I am stuck on my basic question i.e how to reflect changes to other users. I tried reloading data when clicked on cancel( button on form used to cancel any insert,update in tabel) button, it is working OK but taking some time for data to reload.
What I have tried:
I tried to run the code for fetching data in Dataset on every changes, but it is not still reflecting on other user. And I think the is not a good method because it will be time consuming to load data on every change.