Not sure if this is the correct forum or not, but here goes.
I wrote an application in asp a while back that was designed to track employee status in a call center. There were two clients. One was for the phone operators and the other was for the supervisor. Both clients used IE. The employees would click a button to change their status. This would update a database with their name, current status, and the time that they changed their status. Each employee was able to see the status of all the other people in their group and the supervisor was able to see all the employees in the groups they were responsible for. The was a set of rules the each group had and each request to change the status was run against these rules. This was used to regulate how many people were allowed to take a break at one time, how many people were at lunch , and must importantly, when they were on the phone taking a call.
I'm trying to move this to a C# application. In asp, I was able to refresh the data by reloading the page every 30 sec. for the supervisor. I would like to know what type of connection I need for the supervisors client so that the data is updated as soon as it's changed. For instance, if employee #2 is on break, I need the supervisors client to display the amount of time that he has been on break and change his status back as soon as employee #2's status changes on his client.
Here's my question:
Is it possible to have a active connection to an SQL database so that changes are updated immediately?
And what kind of load will this put on the server?
Is this even possible?

Thanks in advance
Jim

Jim,

The connection in both the ASP and ASPX work the same way in the background. Therefore I would suggest you to do it in the same way as you were doing it in asp. ie. refresh the page on every specific interwall. Each time you do a postback, all the variables which you declare are reinitialized unless you have some static variables, which work at the application level.

My suggestion would be to open a connection in the page load and retrive all data. Reload the page in specific intervalls, which will invoke the page load again and again.

Regards
Ganesh
http://ganeshprof.blogspot.com
Find your solution here...

Thanks for the reply, but I wasn't specific enough. I'm converting it to a windows application with c#. I will probably use a system timer or something like that to refresh the data periodically.

If you know of another way, please let me know.

Thanks
Jim