I would like to execute the stored procedure for evey in one hour and load the dataset file into applicationicaion (dropdrown or some asp.net controle) by creating a timer in the Global.asax file .
Very new to this development, please, anyone can publish the code or provide the exact stream of what I need to do in the coding and how to load the asp.net controls (drop-down list or list control).
Thank you at Advance,
Scheduling such tasks is not suitable for an aspx application.
However, there are a few 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
Windows Windows.
ASP.NET - .
- , , -. , . , . (, IIS , .)
, , , Windows. . , .
... -, ? " asp.net", -? .
, , Windows , - . - , . , - , . , .