Firstly thanks for your reply. However, and to be clear enough of what i want to achieve is this. When changes is made in the database, I need some kind of a trigger to push those changes automatically to the UI instead a refresh button. So in my case is the Datagridview. I have also used a timer to refresh the Datagridview every 30 seconds but I felt like that is not an effective solution and don't know what it will do on the network load if I had 30 client refreshing every 30 seconds.
Please assist or anyone, please
I am not sure that there is a way to notify the application about database change. However you could do the following:
1- create a table containing one record only that is numeric. Set its value to 1.
2- each time you update the database, increase the value of this record by one.
3- your application should check the value of this record every 30 seconds or so. If it is changed, then preform the refresh operation, otherwise do not refresh.
it is not that easy to do, but this is what comes into mind.