Need to show a progressbar update
-
Hi Friends, My requirement is something like this. I have a button in my page which invokes a Stored Procedure in the back end. The Stored Procedure is a huge one and takes a whole 3-4 mins to run. What I want is to show that progress in a progressbar in the front end. I can calculate the percentage that has to be shown there, the question is how to make it work? I tried using a TimerControl tool and wrote codes in its Tick event, but as soon as the Stored Procedure starts running, the control is lost and the tick event is not invoked. Can anyone plz help me? In a sorry state right now, trying to find the solution. Thanx 2 all in advance.
-
Hi Friends, My requirement is something like this. I have a button in my page which invokes a Stored Procedure in the back end. The Stored Procedure is a huge one and takes a whole 3-4 mins to run. What I want is to show that progress in a progressbar in the front end. I can calculate the percentage that has to be shown there, the question is how to make it work? I tried using a TimerControl tool and wrote codes in its Tick event, but as soon as the Stored Procedure starts running, the control is lost and the tick event is not invoked. Can anyone plz help me? In a sorry state right now, trying to find the solution. Thanx 2 all in advance.
Your only option really is to use AJAX to make the stored procedure call. Then your page can do whatever it likes, otherwise, the page disappears while the server request is being made.
Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
Hi Friends, My requirement is something like this. I have a button in my page which invokes a Stored Procedure in the back end. The Stored Procedure is a huge one and takes a whole 3-4 mins to run. What I want is to show that progress in a progressbar in the front end. I can calculate the percentage that has to be shown there, the question is how to make it work? I tried using a TimerControl tool and wrote codes in its Tick event, but as soon as the Stored Procedure starts running, the control is lost and the tick event is not invoked. Can anyone plz help me? In a sorry state right now, trying to find the solution. Thanx 2 all in advance.
-
Hi Christian, I'm a bit novice with AJAX. Can you plz guide me through it? I have no idea how to make these things work with AJAX. Gimme a snippet I can work from? Thanks a lot.
-
Try this: http://www.amazon.com/ASP-NET-AJAX-Action-Alessandro-Gallo/dp/1933988142/[^]
But who is the king of all of these folks?
-
Tried a lot but dunno how to make the tick of the timer call once the stored procedure has started to execute? Can anybody help me? I am awfully stuck. Seems a bit foolish to ask but u can consider me a layman when it comes to AJAX.