I am working on an application which will be used by many users at a time. According to the business requirements, the data statistics is displayed to the user based on which he will take decision. At the same time other users are updating the data and viewing the data.
Is there a way in Microsoft .NET environment and MS SQL Server to refresh the data at the client end (datagrid) as soon as some other user makes changes to the related data without the user intervention.
I am using both the web forms and windows forms.
Also, is it possible to refresh the client data without distracting the user from the whole page/form/grid refresh.