Scenario: We have multiple tables in .aspx pages that we manually populate in code behind with data sets that are filled and retrieved from SQL 2008 database via data access layer.
Issue: What is the best way to dynamically update these tables without any user interaction or refreshing of the page?
For example: say the table contains rows of games that are offered for entry. Users enter the games until they are full, then they should disappear from the table. So if user #1 enters the game and fills the last spot, this game should instantly disappear from the table for user #2 who is looking at the table of games.
Looking for a best practice solution which takes performance into affect as the number one priority. Using asp.net 3.5 and sql 2008