How to use Sql Notification ? Please give me an example.

Question

I have Gridview with some data in Windows Application . I want to get updated data and a notification every minute, If there is any updation perform in database.
I want to perform above task using SQL NOTIFICATION

Thanks in advance

Jignesh Trivedi · Answer

hi SQL Notification is itself continuously read data and broad cast it if data changes. please refer http://msdn.microsoft.com/en-us/library/3ht3391b%28v=vs.80%29.aspx http://technet.microsoft.com/en-us/library/ms160889%28v=sql.90%29.aspx Also you can put timer control and refill grid every one minute. hope this will help you.