GridView大数据量导入Excel报错

[feiying102743]

大数据量导出时报System.OutOfMemory Exception错误 网上查了下是内存不足 看了很多帖子都没有说真正能解决的办法 以下是我的代码
Dim style As String = "<style>td{mso-number-format:""\@"";}</style>"
Dtg_Mst.GridLines = GridLines.Both
Dtg_Mst.BorderWidth = 1
Dim i As Integer
For i = 0 To Dtg_Mst.Columns.Count - 1
If Dtg_Mst.Columns(i).GetType().Equals(GetType(CommandField)) Or Dtg_Mst.Columns(i).GetTyp
().Equals(GetType(ButtonField)) Then
Dtg_Mst.Columns(i).Visible = False
End If
Next
PrepareForExcel(Dtg_Mst)
page.Response.Clear()
page.Response.Charset = "GB2312"
page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312")
page.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(filename + ".xls", Encoding.UTF8).ToString())
page.Response.ContentType = "application/ms-excel"
page.EnableViewState = False
Dtg_Mst.AllowPaging = False
Dim myCItrad As New System.Globalization.CultureInfo("ZH-CN", True)
Dim sw As New StringWriter()
Dim htw As New HtmlTextWriter(sw)
Dtg_Mst.RenderControl(htw)
page.Response.Write(style)
page.Response.Write(sw.ToString())
page.Response.End()
谁能给一个真正有效的解决办法 谢谢

[zhou_xuexi]

你不要一下子导出那么多数据，你一下子导出大量数据肯定受不了的

[zhou_xuexi]

还有就是你不要用gridview导出，重新查询用datareader导出，然后导出分多个工作簿

[feiying102743]

有没有在我程序上修改的办法啊