response.end method causing session variable to expire
<p>I am storing the returned sql resultant rows in a session variable ... so that I need not to query again and again</p>

<pre><code>Session["ds"] = datasetname;
</code></pre>

<p>Everything is fine but when I am doing export to excel ... where at last after the export is completed I am calling the method in try/catch</p>

<pre><code>try {
Response.End() 
}

catch {}
</code></pre>

<p>But due to this, my session variable (ds) is getting expired and when I am using it next there is no rows and hence my page displays no data.</p>

<p>I tried going through internet and found that this is a bug it seems as identified by Microsoft and they have provided a hotfix for this but in Windows Vista .... I am running on XP.</p>

<p><a href="http://support.microsoft.com/kb/935778" rel="nofollow">http://support.microsoft.com/kb/935778</a></p>

<p>Is there any other workaround to this problem? Please let me know.</p>

<p>Thanks,
Rahul </p>
