raise trigger event in c#

[priya nallaperumal]

how can i raise an event in asp.net when update a table in sql server 2008 ...
just i am creating trigger.. but i don't know how to raise an event in vs2005 c# asp.net while trigger fired.
plz  help me..
thanks..

[Mostafa Anoosheh]

Hello,
I think you need to use SqlDependency Class
Read more at
Using SqlDependency for data change events
SqlDependency - Creating a Smarter Cache
Using SqlDependency in a Windows Application

Best regards,
Mostafa Anoosheh