Click here to Skip to main content
15,352,321 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello, I'm using SQLDependency to get table notifications. Inside my OnChangeEventHandler I want to specifically know which row has been modified. How can I do that? I understand that on table from SqlNotificationEventArgs, I can know if this is insert or update or delete operations. But how can I know which specific row has been changed?
dbrenth 5-Dec-13 14:11pm
I must be misunderstanding something. To know which specific row has been changed, just look at the WHERE clause in your SQL statement.

1 solution

If i have understood the question correctly that means you want to know which row of table has been affected.

You can have an identity column in your table which will can provide you the information of add,update, or delete. and if you want to keep a track u can add record to log file for reference

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900