sql query in real time...ajax?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Hi all,

I'm looking for a way to show my users the progress of their sql
queries. I've implemented Microsoft Ajax in order to show a progress
bar, but I would love to be able to show:

number of rows loaded vs total rows

I tried a few searches for this, but haven't come up with the right
key words I guess. Right now I have zilch. So, it's easy enough to get
a count of the total rows before starting. I guess I need to query the
datasource every .5 to 1 second and display how many rows it has
retrieved already. This way the user has some idea how long the whole
thing is going to take.

Any ideas?

Thanks in advance.

.



Relevant Pages

  • Re: sql query in real time...ajax?
    ... If user gets lucky and it ends in 9 seconds then you finish your bar early ... If not lucky then you simply push that indicator a little back. ... I'm looking for a way to show my users the progress of their sql ... a count of the total rows before starting. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Freeze in the middle of a spreadsheet.
    ... split is really useful Kevin but I cannot get them to work together! ... the screen and then apply a freeze to keep the top still it doesn't work. ... top of the vertical scroll bar is the split pane icon. ... Then click in the bottom window and bring your total rows into view. ...
    (microsoft.public.excel.misc)