A
Antonio
My web page allows a user to click a button for a report to be created.
When they click, the code calls a web service which accesses SQL
Server and calls a stored procedure. THE SP takes 2 minutes to run.
The web service return data type is DataSet and the dataset is handed
to a method which creates an excel file for the user to download. It
uses code such as
response.ContentType = "application/vnd.ms-excel";
and
dataGrid.RenderControl(htmlWrite);
I obtained that excel block of code from this group!
But I think that if a user might be clicking stop after running the
code that the IIS server is memory leaking. We have had to run
iisreset to get going again. The memory does free up on it's own but
not fast.
When someone clicks stop does the web service still keep going?
Any help is suggested for me?
When they click, the code calls a web service which accesses SQL
Server and calls a stored procedure. THE SP takes 2 minutes to run.
The web service return data type is DataSet and the dataset is handed
to a method which creates an excel file for the user to download. It
uses code such as
response.ContentType = "application/vnd.ms-excel";
and
dataGrid.RenderControl(htmlWrite);
I obtained that excel block of code from this group!
But I think that if a user might be clicking stop after running the
code that the IIS server is memory leaking. We have had to run
iisreset to get going again. The memory does free up on it's own but
not fast.
When someone clicks stop does the web service still keep going?
Any help is suggested for me?