Getting database change events to my application

[Guest]

Hi,


I want to hookup some database change events automatically to my .NET
application. The backend is SQLServer 2003. Is this possible? How do I
get notified automatically of changes in my database?


Samples and URLs would help.


Thanks,
VG.

 

[EJD]

VG,

This is a very interesting question, and I suppose there are a variety
of ways to do it depending on whether or not you're using Winforms or
ASP.Net. But if it's asp.net then to give credit where it is due you
may want to check Peter Bromberg's article:
http://www.eggheadcafe.com/articles/20040607.asp
Or this one...
http://weblogs.asp.net/jgalloway/archive/2005/05/07/406056.aspx
which refers back to the first. Both articles deal with asp.net and
you'll see some big differences between 1.1 and 2. Hope this helps to
get you started...
Eric