Auto-Refresh for SQL Grids displaying SQL Server Data
Functionallity of the Application--
"We have a large legacy application using SQL Server 2000. We're gradually adding .NET WinForms controls to it, using the IdeaBlade DevForce package as the data access layer, and primarily Infragistics Grids and other controls for display. We're using Visual Studio 2005, and plan to migrate to SQL Server 2005 pending validation, but I need a solution that works for 2000."
Problem description--
"I would like a mechanism to allow grid displays to automatically update when any change is made to one of the tables that contributes data to it. I'd like the mechanism to be event driven using some kind of publish/subscribe model. "
Challenges-
"Instead of using notification services ,any triggers or extended stored procedures if suffice this issues ,help me out in this regard."
