Exception of type System.OutOfMem oryException is thrown

[karups]

Hi,
There are several pages that occasionally start throwing
System.OutOfMem oryException and "The type initializer for
"Microsoft.Prac tices.Enterpris eLibrary.Data.I nstrumentation. DataCommandFail edEvent
exception."
The problem goes away after iisreset .

- Actually on Excel Exporting this error happens and stops all the
applications in the server
- It exceeds more than 1GB size, i hope so in server
-

How to solve this problem? How to reduce size of Dataset when exporting
to excel file?
Help me out in this...
Thanks in advance

-karups

[karups]

My application will have a fetch button.
As soon as we click the fetch button..It calls a Stored Procedure.
The stored procedure will return a dataset back(huge on with rows 25000
and col:52)...
I export this dataset to excel using this code

Response.Clear( );
Response.AddHea der("content-disposition",
"attachment;fil ename="+filenam e+".xls");
Response.Charse t = "";
this.EnableView State=false;
Response.Cache. SetCacheability (HttpCacheabili ty.NoCache);
Response.Conten tType = "applicatio n/vnd.xls";
System.IO.Strin gWriter stringWrite = new System.IO.Strin gWriter();
System.Web.UI.H tmlTextWriter htmlWrite = new
HtmlTextWriter( stringWrite);
DataGrid myDataGrid=new DataGrid();
myDataGrid.Data Source=dsReport .Tables[1];
myDataGrid.Data Bind();
myDataGrid.Rend erControl(htmlW rite);
Response.Write( stringWrite.ToS tring());
Response.End();

While doing this i get the OutOfMemoryExce ption..