How to refresh a form on a database change?

walterb

I've got an application that I can't use a tradtional database trigger on because of performance issues.

I would like to refresh the page /form when data changes on a certain field in the database.

I realize that asp.net is stateless, but is it possible to poll the database using javascript every x number minutes then have it refresh if the value changes?

thanks in advance.

r035198x

Quote:

Originally Posted by walterb

I've got an application that I can't use a tradtional database trigger on because of performance issues.

I would like to refresh the page /form when data changes on a certain field in the database.

I realize that asp.net is stateless, but is it possible to poll the database using javascript every x number minutes then have it refresh if the value changes?

thanks in advance.

Javascript doesn't connect to databases. You'd need to use AJAX.

walterb

Thanks. Do you have a link to any examples of ajax code testing a database condition?

Quote:

Originally Posted by r035198x

Javascript doesn't connect to databases. You'd need to use AJAX.

r035198x

Quote:

Originally Posted by walterb

Thanks. Do you have a link to any examples of ajax code testing a database condition?

You'd have to ask in the Javascript forum. You'd need to do your server side scripting all the same. Only this time you send the result to an Ajax function which inturn passes it to a Javascript function which (sigh) can update the page details without the page having been (visibly) submitted.

How to refresh a form on a database change?

re: How to refresh a form on a database change?

re: How to refresh a form on a database change?

re: How to refresh a form on a database change?

Similar .NET Framework bytes

/bytes/development

/bytes/it

/bytes/about