raise trigger event in c#

2 posts, 0 answers
  1. priya nallaperumal
    priya nallaperumal avatar
    23 posts
    Member since:
    Nov 2009

    Posted 16 Jan 2010 Link to this post

    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..
  2. Mostafa Anoosheh
    Mostafa Anoosheh avatar
    462 posts
    Member since:
    Nov 2005

    Posted 09 Feb 2010 Link to this post

    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
Back to Top