Auto Refresh ASP page on Client Site on Database updates.

Sachin75 used Ask the Experts™

I would like to know that ,is there any way that the asp page would get refreshed automatically when there is an update in
a tbale in SQL Server. The page should get refresh automatically on updates in SQL Server. The user will not hit refresh button neither I want the page to have meta-refresh tag.

Pls let me know..


Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You could have a XMLHttp timer request polling the server transparent to the user.
<meta http-equiv="Refresh" content="5; URL=">

If you insert meta-refresh tag, it will be refresh without events on the server.
You need some communication between server and client. Use javascript with timer to change src of one js file, and if you are ready with the table in SQL, then change js file with source to reload page.

Thank you! This is the first time ever I have been awarded a C ;)  If You only had asked I could have given you more detailed code. Please read guidelines.
from guidelines,

"C: Because Experts' reliability are often judged by their grading records, many Experts would like the opportunity to clarify if you have questions about their solutions. If you have given the Expert(s) ample time to respond to your clarification posts and you have responded to each of their posts providing requested information; or if the answers, after clarification, lack finality or do not completely address the issue presented, then a "C" grade is an option. You also have the option here of just asking Community Support to delete the question. "

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial