database watch

Like the FileSystemWatcher class to watch file do we have any method to watch sql database table(insert,update, delete) like what trigger doing of sql.

yeah, we got triggers (http://www.google.nl/search?hl=nl&q=mssql+trigger&meta=) to take care of that.

you can create a trigger for a database table, look it up in the helpfiles or on google

a trigger can fire and do some actions on an insert, update or delete in the table its defined for

That is one solution from database point. I want entire solution from .net.

:p

:o i think i didn´t read your post well enough. Sorry :o

i dont know of any databasewatcher. i think it will be a pain to build one, much different types of databases, can´t watch changes on the db-file(s) because lot of things happen in memory before the changes are written to the file(s)

i think i would rely on triggers to watch for specific changes