«

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 ?

Try this way...

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

"bnob" <> wrote in message
news:%...
> 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 a formulé ce vendredi :
> Try this way...
>
> http://www.netomatix.com/gridexporttocsv.aspx
>
> "bnob" <> wrote in message
> news:%...
>> 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 ?
>>
>>
>>
>>
>>
>>

It doesn't work....

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