hi to all,
my question is how can the database notify the user if there is a new inserted data on the database...like for example, i inserted a new data then when i go to the display reports page i would see a link saying New Report Recieved and this will take me to the details of the new inserted data or the report sent by another user..is this doable?? and by the way im using asp.net 2.0 and a sql database...thx...
Maybe you can use Query Notifications which is a new feature available in SQL Server 2005.
There are 3 ways to implement it:
- Low-level implementation (provided by SqlNotificationRequest class)
- High-level implementation (provided by SqlDependency class)
- SqlCacheDependency helper classes, in case you want to detect data changes for refresh caches.
More information:http://msdn2.microsoft.com/en-us/library/t9x04ed2.aspx
No comments:
Post a Comment