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

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

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.

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

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 :

Code:

---

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

---

Code Behind :

Code:

---

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

---

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.