Event/trigger/notification from the sql server 2005 to C# application

Question

Hi Experts,

I am new to sql stuff. Please if you could guide me, I have a table that gets the data about status of machines and its connected devices, continousouly (large chunk of data).  All the data is in the table in binary form. Suppose if device is active its bit is set as 1 otherwise 0.

My problem is when 1 bit data is entered in the table for a particular device, i.e device is active, c# application should tell/notifies the user, device is active or vice versa.

So I am thinking to put trigger on my table that check after insert sql query if the particular bit is entered 1. If yes then tell the user. But how C# application will come to know the result of the trigger operation on table? Any code example would be helpful.

Thanks n regards,

---

Maverick

Answer 1

Hi,


From your description, it seems that you want to know if the trigger be executed, right?

In your case, I think you can create trigger which adds a record to a table which you predefined, and then create a Windows Service, check the table

periodicity.

For code, you can refer to System.Timer and System.Data.SqlClient in C#.

http://msdn.microsoft.com/en-us/library/system.timers.timer.aspx

http://msdn.microsoft.com/en-us/library/system.data.sqlclient(VS.80).aspx

Thanks.

---

Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.