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....
Loading

Ajay PatelPosted May 16, 2013, 7:19 AM
Riddhi ValechaPosted May 15, 2013, 12:30 AM
Database Design -
TableName-Person
----------
ID;pk;autoincrement;
FName;varchar(50);
LName;varchar(50)
Age;int
------------
Change the connection string.
-----------
Rest code is attached.
Ajay PatelPosted May 14, 2013, 8:33 AM
Riddhi ValechaPosted May 13, 2013, 11:43 PM
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 PatelPosted May 13, 2013, 7:46 AM
But this reply doesn't match with my question.
you have replied for how to show notification.
Riddhi ValechaPosted May 10, 2013, 9:13 AM
There is a control - NotificationIcon in Windows application. Use that.
--
Eg- take 2 or 3 *.ico files.
Set the Icon Property through coding part.
-----