Export datagrid to Excel with a lot of rows

[bnob]

Hello

Here's my code to export a datagrid to Exel :
Response.Clear()
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
Dim monStringWriter As StringWriter = New StringWriter
Dim monHtmlTextWriter As HtmlTextWriter = New
HtmlTextWriter(monStringWriter)
monDG.RenderControl(monHtmlTextWriter)
Response.Write(monStringWriter.ToString())
Response.End()

It's work perfectly, but when my datagrid displays for exeample 10000 rows,
the export doesn't work.
Instead I have the page impossible to display !!!!

Any idea ?

 

[Winista]

Try this way...

http://www.netomatix.com/gridexporttocsv.aspx

 

[Amirallia]

Winista a formulé ce vendredi :

Try this way...

http://www.netomatix.com/gridexporttocsv.aspx

It doesn't work....

No file is created to the server... It' directely display a white page
!!!