VB.Net - Displaying Update Triggered Table Records

Good Day Experts!

I have an idea to achieve the end result but need some help.

We need to know when there are overrides performed on our system by DataEntry.  When an override is performed,  3 fields are updated in a table.

I thought to do the following:
1)Put an update Trigger on that table and insert a record in a staging table with the data
   from those 3 fields
2)Give the 2 Supervisors a console application to monitor these records
3)Somehow figure out when the console application is open to have it automatically
   refresh the DataGrid each time a new staging table record is inserted

Can you offer any advice how to get this automatic refresh to work? Or, perhaps offer an alternative?

Thanks,
jimbo99999
Jimbo99999Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jimbo99999Author Commented:
You know, after hitting enter to post the question, I thought of something.  There already is that original table that gets the 3 fields updated when an override is performed.  Maybe is there some kind of "listener" that knows when that happens to display it in the DataGrid of my console application?

Thanks,
jimbo99999
0
CodeCruiserCommented:
Datagrid in console application? I guess you mean computer console

If you are using SQL Server, look into SQL Dependency class

http://www.codeproject.com/Articles/12335/Using-SqlDependency-for-data-change-events
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jimbo99999Author Commented:
Thanks for responding.  Sorry for the poor word choice. I was menaing to refernece just a regular windows VB.Net application.

I will take a look at the link your provided.

Thanks,
jimbo99999
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.