real time data..how to refresh every once in a second

[bnathvbdotnet]

I have about 20 text boxes on a web form and the data source is a oracle table. the content in the table changes every once in a second. So I need to refresh the contents on the web form every once in a second. How can I achieve this?

thank you
nath

[hellswraith]

You would need to implement something other than static html. Maybe use a java applet like some games use? Every second refreshing the page would be a pain in the ass for the user.

[Edneeis]

It may be better to have a windows application that interfaces via the web (web services or remoting).

[Rio]

I don't know about "how-to" refresh directly within the oracle, but I think you can use this trick for your aspx page :

HTML :

<script language="javascript">
		setTimeout('location.href ="Default.aspx"',1000);
		</script>

Code Behind :

Response.Cache.SetExpires(DateTime.Now.AddSeconds(1))

[hellswraith]

You can do it, but it will be horrible for the user, look into a java applet or something if it has to be real time from the web, if it can be a user app, then yes, what edneeis said, windows app.