Refresh page/objects on data change

[Phil]

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.

 

[Phil]

I feared as much - auto-refreshing the page periodically looks bad as
it flashes. AJAX - FLA (four letter acronym?).

Phil.

Phil,

In Asp.Net technology server can't notify client. The way to go is to get
the client query the server periodically for changes.

The simplest thing is to auto-refresh the page every xx seconds:
<meta http-equiv="refresh" content="xx">

Practically, you will likely want to look at AJAX to avoid full-scale page
postbacks.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

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.

 

[Guest]

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!
***************************

 

[Eliyahu Goldin]

Phil,

In Asp.Net technology server can't notify client. The way to go is to get
the client query the server periodically for changes.

The simplest thing is to auto-refresh the page every xx seconds:
<meta http-equiv="refresh" content="xx">

Practically, you will likely want to look at AJAX to avoid full-scale page
postbacks.

 

[Eliyahu Goldin]

Yes, auto-refreshing does looks bad. AJAX should not. It's a technology for
posting/getting just what you need.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

I feared as much - auto-refreshing the page periodically looks bad as
it flashes. AJAX - FLA (four letter acronym?).

Phil.

Phil,

In Asp.Net technology server can't notify client. The way to go is to get
the client query the server periodically for changes.

The simplest thing is to auto-refresh the page every xx seconds:
<meta http-equiv="refresh" content="xx">

Practically, you will likely want to look at AJAX to avoid full-scale
page
postbacks.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

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.