How to monitor the change of the database so as to flush the treeview?

Question

target: whenever the table in the database changes, the treeview will reload the new contents of the table.

Is there any good methods to solve this problem? thank u

Answer 1

If your are using SQL Server check out SqlDependency. Here are links to MSDN with examples of how SqlDependency can be used:

http://msdn.microsoft.com/en-us/library/62xk7953%28VS.80%29.aspx
http://msdn.microsoft.com/en-us/library/9dz445ks%28VS.80%29.aspx

Answer 2

I'm thinking loud here.. if you can't use SqlDependency, the next thing you can try is FileWatcher, but you won't know what changed..