I'm using this to export a gridview to excel, the problem being that once i hit over 10000 records or so, it doesn't change and just displays the gridview. is there a different way to do this? is there a limitation to the stringwriter or htmltextwriter class?
i need to export about 50k lines to excel, and the data has to be manipulated before output, otherwise i would just export it out of sqlserver.
Private Sub ExportGridView()
Dim at As String = "attachment; filename=" & "TEST" & ".xls"
Response.ContentType = "application/ms-excel"
Dim sw As StringWriter = New StringWriter
Dim htw As HtmlTextWriter = New HtmlTextWriter(sw)
Dim frm As HtmlForm = New HtmlForm
frm.Attributes("runat") = "server"