Here is the situation. Within a vb application we are using a webservice. The application is using a async call to the webservice to execute a stored proc that is used to fill a report. The webmethod in the webservice returns a dataset.
When I go to run the report the first time I get the dataset back after the Async call (System.IAsyncResult) is finished and all is well. I populate my local dataset variable with the results of the webservice method.
However, if I goto run the report a second time I do not get a dataset returned. And this is after the IAsyncResult.IsCompleted comes back as true (i.e., the process is completed). At this point I ran SQL Server Profiler to check and see if the stored proc was executing and it was returning the data but seems like it is not populating the dataset in the webmethod.
Does anyone have any advice.
Thanks in advance!!!
Frandazzo
When I go to run the report the first time I get the dataset back after the Async call (System.IAsyncResult) is finished and all is well. I populate my local dataset variable with the results of the webservice method.
However, if I goto run the report a second time I do not get a dataset returned. And this is after the IAsyncResult.IsCompleted comes back as true (i.e., the process is completed). At this point I ran SQL Server Profiler to check and see if the stored proc was executing and it was returning the data but seems like it is not populating the dataset in the webmethod.
Does anyone have any advice.
Thanks in advance!!!
Frandazzo