C# SQL Trigger Example RRS feed

  • Question

  • Is it possible to have a WinForm/WPF app that waits on a new record to be inserted to SQL database and have event thrown when inserted?  Meaning, I would like to have an app wait for a new record.  Once inserted, an event is thrown which will then update my UI with info from new record to textboxes, etc.  I don't want to have to repeatly poll database to see if there are new records.  Would be nice to fire an event.  Does anyone have examples and/or links on how to do so.  Eventually would like to move to a service to wait and react to new records, but an app will do for now.  TIA.
    Wednesday, December 2, 2009 2:52 PM