Web Form Progress Bar

[aj]

Alan, you can achieve this by using XMLHttp Async
functionality in a javascript file.

Create an aspx page in which execute long running SQL
query, then do an XMLhttp post to that page from a js
function.
In the javascript create 2 funtion
Call LoadData in the window onload event.

var objXMLReq;
function LoadData() {
objXMLReq = new ActiveXObject
("Microsoft.XMLHttp");
var DataUrl = 'http://localhost/Query.aspx';

objXMLReq.onreadystatechange =
ManageASyncXMLHTTPOperation;
objXMLReq.open("POST", DataUrl, true);
objXMLReq.setRequestHeader('Content-
type', 'text/xml');
objXMLReq.send();

//Display Progress bar("Retrieving data...");
}

function ManageASyncXMLHTTPOperationDTL() {
switch (objXMLReq.readyState) {

case 2, 3:
break;

case 4:
//Hide the progress bar
//Display the data
div.innherText=objXMLReq.responseText;
}
}

-----Original Message-----
Does anyone know of web form Progress Bar controls or simulations for long-running SQLServer process?

Is it possible to use a conceptual method such as

1. Have SQLServer post status updates or number of seconds elapsed to database table, and

2. Have web form post commands to retrieve data from the table basedon a timer, but inhibit web form redrawing until SQLServer table progressnumbers
pass certain threshholds?

Thanks.

Alan
___________________________
Alan Z. Scharf
GrapeVine Systems
New York City
.

[Rick Strahl [MVP]]

Downside here is it'll only work with IE. For multi-browser this is not an
option.

If only the HTML standard or JScript would include a standard built in HTTP
component - so useful in so many situations.

+++ Rick ---

--

Rick Strahl
West Wind Technologies
http://www.west-wind.com/
http://www.west-wind.com/wwHelp
----------------------------------
Making waves on the Web
"aj" <ja********@yahoo.com> wrote in message
news:0b****************************@phx.gbl...

Alan, you can achieve this by using XMLHttp Async
functionality in a javascript file.

Create an aspx page in which execute long running SQL
query, then do an XMLhttp post to that page from a js
function.
In the javascript create 2 funtion
Call LoadData in the window onload event.

var objXMLReq;
function LoadData() {
objXMLReq = new ActiveXObject
("Microsoft.XMLHttp");
var DataUrl = 'http://localhost/Query.aspx';

objXMLReq.onreadystatechange =
ManageASyncXMLHTTPOperation;
objXMLReq.open("POST", DataUrl, true);
objXMLReq.setRequestHeader('Content-
type', 'text/xml');
objXMLReq.send();

//Display Progress bar("Retrieving data...");
}

function ManageASyncXMLHTTPOperationDTL() {
switch (objXMLReq.readyState) {

case 2, 3:
break;

case 4:
//Hide the progress bar
//Display the data
div.innherText=objXMLReq.responseText;
}
}

-----Original Message-----
Does anyone know of web form Progress Bar controls or

simulations for

long-running SQLServer process?

Is it possible to use a conceptual method such as

1. Have SQLServer post status updates or number of

seconds elapsed to

database table, and

2. Have web form post commands to retrieve data from

the table based

on a timer, but inhibit web form redrawing until

SQLServer table progress

numbers
pass certain threshholds?

Thanks.

Alan
___________________________
Alan Z. Scharf
GrapeVine Systems
New York City
.

[Alan Z. Scharf]

aj,

Thanks very much for your detailed reply.

I've had so many people tell me progress bars for backend SQL queries
couldn't be done in web forms.

Both your generous recommendation and the other extensive responses here
regarding multithreading convince me that there's always a way o do
something.

Regards,

Alan
"aj" <ja********@yahoo.com> wrote in message
news:0b****************************@phx.gbl...

Alan, you can achieve this by using XMLHttp Async
functionality in a javascript file.

Create an aspx page in which execute long running SQL
query, then do an XMLhttp post to that page from a js
function.
In the javascript create 2 funtion
Call LoadData in the window onload event.

var objXMLReq;
function LoadData() {
objXMLReq = new ActiveXObject
("Microsoft.XMLHttp");
var DataUrl = 'http://localhost/Query.aspx';

objXMLReq.onreadystatechange =
ManageASyncXMLHTTPOperation;
objXMLReq.open("POST", DataUrl, true);
objXMLReq.setRequestHeader('Content-
type', 'text/xml');
objXMLReq.send();

//Display Progress bar("Retrieving data...");
}

function ManageASyncXMLHTTPOperationDTL() {
switch (objXMLReq.readyState) {

case 2, 3:
break;

case 4:
//Hide the progress bar
//Display the data
div.innherText=objXMLReq.responseText;
}
}

-----Original Message-----
Does anyone know of web form Progress Bar controls or

simulations for

long-running SQLServer process?

Is it possible to use a conceptual method such as

1. Have SQLServer post status updates or number of

seconds elapsed to

database table, and

2. Have web form post commands to retrieve data from

the table based

on a timer, but inhibit web form redrawing until

SQLServer table progress

numbers
pass certain threshholds?

Thanks.

Alan
___________________________
Alan Z. Scharf
GrapeVine Systems
New York City
.

[Lewis Wang [MSFT]]

Hi Alan,

I have replied your post in another
thread<microsoft.public.dotnet.framework.aspnet.we bcontrols>, titled: <Web
Form Progress Bar Control>.

I past the link here for your reference:

http://groups.google.com/groups?hl=e...readm=OiAxCajY
DHA.2448%40TK2MSFTNGP09.phx.gbl&rnum=1&prev=/groups%3Fq%3DWeb%2BForm%2BProgr
ess%2BBar%2BControl%2B%2Bv-lwang%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8
%26selm%3DOiAxCajYDHA.2448%2540TK2MSFTNGP09.phx.gb l%26rnum%3D1

Best regards,
Lewis

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Reply-To: "Alan Z. Scharf" <as*****@grapevines.com>
| From: "Alan Z. Scharf" <as*****@grapevines.com>
| References: <#0**************@TK2MSFTNGP09.phx.gbl>
<0b****************************@phx.gbl>
| Subject: Re: Web Form Progress Bar
| Date: Thu, 14 Aug 2003 04:13:21 -0400
| Lines: 89
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.3718.0
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3718.0
| Message-ID: <eB*************@tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: 207-237-240-45.c3-0.nyw-ubr2.nyr-nyw.ny.cable.rcn.com
207.237.240.45
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:167771
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| aj,
|
| Thanks very much for your detailed reply.
|
| I've had so many people tell me progress bars for backend SQL queries
| couldn't be done in web forms.
|
| Both your generous recommendation and the other extensive responses here
| regarding multithreading convince me that there's always a way o do
| something.
|
| Regards,
|
| Alan
|
|
| "aj" <ja********@yahoo.com> wrote in message
| news:0b****************************@phx.gbl...
| > Alan, you can achieve this by using XMLHttp Async
| > functionality in a javascript file.
| >
| > Create an aspx page in which execute long running SQL
| > query, then do an XMLhttp post to that page from a js
| > function.
| >
| >
| > In the javascript create 2 funtion
| > Call LoadData in the window onload event.
| >
| > var objXMLReq;
| > function LoadData() {
| > objXMLReq = new ActiveXObject
| > ("Microsoft.XMLHttp");
| > var DataUrl = 'http://localhost/Query.aspx';
| >
| > objXMLReq.onreadystatechange =
| > ManageASyncXMLHTTPOperation;
| > objXMLReq.open("POST", DataUrl, true);
| > objXMLReq.setRequestHeader('Content-
| > type', 'text/xml');
| > objXMLReq.send();
| >
| > //Display Progress bar("Retrieving data...");
| > }
| >
| > function ManageASyncXMLHTTPOperationDTL() {
| > switch (objXMLReq.readyState) {
| >
| > case 2, 3:
| > break;
| >
| > case 4:
| > //Hide the progress bar
| > //Display the data
| > div.innherText=objXMLReq.responseText;
| > }
| > }
| >
| > >-----Original Message-----
| > >Does anyone know of web form Progress Bar controls or
| > simulations for
| > > long-running SQLServer process?
| > >
| > > Is it possible to use a conceptual method such as
| > >
| > > 1. Have SQLServer post status updates or number of
| > seconds elapsed to
| > > database table, and
| > >
| > > 2. Have web form post commands to retrieve data from
| > the table based
| > >on a timer, but inhibit web form redrawing until
| > SQLServer table progress
| > >numbers
| > >pass certain threshholds?
| > >
| > > Thanks.
| > >
| > > Alan
| > >___________________________
| > >Alan Z. Scharf
| > >GrapeVine Systems
| > >New York City
| > >
| > >
| > >.
| > >
|
|
|

[Alan Z. Scharf]

oj,

Thanks very much for the help and code. I will give it a try.

Regards,

Alan

"aj" <ja********@yahoo.com> wrote in message
news:0b****************************@phx.gbl...

Alan, you can achieve this by using XMLHttp Async
functionality in a javascript file.

Create an aspx page in which execute long running SQL
query, then do an XMLhttp post to that page from a js
function.
In the javascript create 2 funtion
Call LoadData in the window onload event.

var objXMLReq;
function LoadData() {
objXMLReq = new ActiveXObject
("Microsoft.XMLHttp");
var DataUrl = 'http://localhost/Query.aspx';

objXMLReq.onreadystatechange =
ManageASyncXMLHTTPOperation;
objXMLReq.open("POST", DataUrl, true);
objXMLReq.setRequestHeader('Content-
type', 'text/xml');
objXMLReq.send();

//Display Progress bar("Retrieving data...");
}

function ManageASyncXMLHTTPOperationDTL() {
switch (objXMLReq.readyState) {

case 2, 3:
break;

case 4:
//Hide the progress bar
//Display the data
div.innherText=objXMLReq.responseText;
}
}

-----Original Message-----
Does anyone know of web form Progress Bar controls or

simulations for

long-running SQLServer process?

Is it possible to use a conceptual method such as

1. Have SQLServer post status updates or number of

seconds elapsed to

database table, and

2. Have web form post commands to retrieve data from

the table based

on a timer, but inhibit web form redrawing until

SQLServer table progress

numbers
pass certain threshholds?

Thanks.

Alan
___________________________
Alan Z. Scharf
GrapeVine Systems
New York City
.