In SQL Server, there are mechanisms to alert the server that a change has
happened, but they do not persist to the client (stateless system). You can
refresh the page, of course, but that can look ugly. It is possible to use
Ajax, but be careful that you are not duplicating the data transfer to simply
avoid a postback. You can Ajax poll and force a refresh only on changes,
which is a good compromise in many cases.
ActiveX and Java controls provide other options, but require other coding
skills than .NET, making them less useful for most people.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"Phil" wrote:
Hi.
A fairly basic sort of 'direction to go in' question of the type that
can be hard to find an answer to!
I am using ASP.NET (framework 1.1) to present data on web pages (IIS
5.0 / IE6) from tables (in SQL Server 8).
What are the best methods of getting the web page being viewed to
update automatically when data in the table changes? Not necessarily a
detailed answer, but a good pointer please.
Cheers,
Phil.