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
    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
    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
    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
    •