Notify clients?

[Guest]

Part of a c# WinForms system I'm developing allows department managers to log
tasks for their employees. The task information is saved to SQL Server db,
and appears in a 'tasks' pane when users load the system.

What is the best way to update a users tasks pane if a task is logged for
them when they already have the system open? When the task is logged to the
db, i need to force the user it's logged for to have their pane refreshed..

Thanks

 

[Greg Burns]

May want to research CacheSync (aka Query Notifications). Not sure if SQL
2005 and .NET 2.0 are both requirements or not.

Greg

 

[Greg Burns]

http://msdn2.microsoft.com/en-us/library/ms178604.aspx

Doesn't look like you can use this outside of ASP.NET app. But I could be
wrong about that too.

 

[Greg Burns]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/querynotification.asp

 

[Guest]

Hi Greg - thanks for the links, looks interesting.
Unfortunately don't have SQL 2005 on all our production servers yet, so
can't implement this approach.

Definitely one to work with in the future though!