excel export giving memory error
I am exporting the data to excel.If i have huge data its giving memroy error means it creates an enormous amount of objects in memory and the .Net framework restarts the asp.net process to prevent it from eating all the server's memory.
This means that all asp.net applications running on that server would be restarted (loosing connections, sessions data...)
log shows below error
aspnet_wp.exe (PID: 2616) was recycled because memory consumption exceeded the 305 MB (60 percent of available RAM).
my code is
Dim adapter As New SqlDataAdapter(sql, con) '
Dim myDataSet As New DataSet
Catch ex As Exception
Response.Charset = ""
Response.ContentType = "application/vnd.ms-excel" ' set the content type
Response.AddHeader("Content-Disposition", " attachment; filename=urreportname.xls")
Dim stringWrite As New System.IO.StringWriter
Dim htmlWrite As New System.Web.UI.HtmlTextWriter(stringWrite)
Dim dg As New System.Web.UI.WebControls.DataGrid
dg.DataSource = myDataSet.Tables(0) ' it is here where u need to assign ur datatable