Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4

Thread: database watch

  1. #1
    Regular Coder
    Join Date
    Jun 2002
    Posts
    156
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.

  2. #2
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    yeah, we got triggers 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
    I am the luckiest man in the world

  3. #3
    Regular Coder
    Join Date
    Jun 2002
    Posts
    156
    Thanks
    0
    Thanked 0 Times in 0 Posts
    That is one solution from database point. I want entire solution from .net.


  4. #4
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    i think i didnīt read your post well enough. Sorry

    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
    I am the luckiest man in the world


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •