Hi Imar,
is it possible to use Ajax to show a progress bar in my .aspx page when I run a stored procedure?

Thanks in advance.

Luigi

The difficult part of this idea is that while Ajax is asynchronous and happening in the background, it's still working against the standard HTTP protocol. You send a request to the server and wait an unknown time until the response comes back.

In order to build something that provides progress you'd have to do several things:
- Spin off a thread to do your background work so the initial call is not blocked.
- Maintain knowledge of that thread (i.e. persist a thread ID in user session or similar)
- Provide some mechanism on an object in that thread context for accessing progress (possibly difficult with a SQL call, depending on what you are doing in SQL it might be easier or harder)
- Change your client code behavior from a single AJAX call to run the process, to a call that starts the process, then sets up a timer for status polling.

-Peter
compiledthoughts.com

Thank you Planoie, so it's not so easy that I thought.

L

If you don't really need a progress bar to indicate progress, but only need a "please wait" message (like a Spinner image), you can also use an UpdatePanel in combination with an UpdateProgress control.

Not perfect, but it may do the trick.

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.