asp.netvb.nettimerglobal-asax

Creating the Timer in Global.asax file

I would like to execute a storedprocedure for evey one hour and have to load the dataset in applicaion(dropdrown or some asp.net controle) by creating the timer in Global.asax file.

Am very very new for this kind of development, please any one could post the code or provide the exact flow what i have to do in coding and how to load the asp.net controls(dropdown or list controle).

Thank You in Advance,

Solution

  • Scheduling tasks like that is not an appropriate use for an aspx application.

    However, there are several hacks/workarounds you can try:

    http://www.codeproject.com/Articles/12117/Simulate-a-Windows-Service-using-ASP-NET-to-run-sc

    http://www.west-wind.com/weblog/posts/2007/May/10/Forcing-an-ASPNET-Application-to-stay-alive

    http://www.mikesdotnetting.com/Article/129/Simple-task-Scheduling-using-Global.asax

    You would be much better off creating windows service or use the built-in Windows scheduler.