Alert Notification in C#

Question

Hello I need help for following question. I want to get notification when there is any update in Database in Sql Server. Is there any Idea to do this ? If you are suggesting about SqlDependancy then Plz Provide full example. Thanks....

Riddhi Valecha · Answer

Hi... Database Design - TableName-Person ---------- ID;pk;autoincrement; FName;varchar(50); LName;varchar(50) Age;int ------------ Change the connection string. ----------- Rest code is attached.

Ajay Patel · Answer

thanks for reply. But you are going wrong. You know trigger in Database ? when any table is updated then trigger related it get fired. i want to do like that in .Net.

Ajay Patel · Answer

Yes if there is any data update in DB then I need to get notification

Riddhi Valecha · Answer

Hi... Can you explain the scenario in details?? As far as I understand your requirement is- Whenever any DML(Data Manipulation Language) Query (Eg-Insert; Update; Delete) is fired the user should know about it. Is this all ?? Or is there any other requirement??

Ajay Patel · Answer

Thanks for reply But this reply doesn't match with my question. you have replied for how to show notification.

Riddhi Valecha · Answer

Hi... There is a control - NotificationIcon in Windows application. Use that. -- Eg- take 2 or 3 *.ico files. Set the Icon Property through coding part. -----