detect database changes using a c# application

[Reddy]

Hi,

I am in the process of developing a C# application which runs continuously
in the background on the server. It should grab the changes in the database
and send the modified or new results to me in an email.


I heard that it could be done using SQL Server Jobs. But I am looking to
develop it using a C# application.


Can anyone help how to do this or point me to some resources with sample
source codes.

Thanks,

Reddy

 

[Ignacio Machin]

Hi,

I agreed that the best way of doing this is using SQL itself, now if you
wanna do it in C# then you will have to create a windows service with a
timer, take a look at :
http://msdn.microsoft.com/library/d...kthroughcreatingwindowsserviceapplication.asp
for a walkthrough of creating a windows service.

Hope this help,