Exporting Gridview to CSV

kadjw · September 18th, 2006, 08:31 AM

Hi All

Does anyone know of any articles or the code to export Gridview control data to a CSV file format. I have found plenty in C# but not in VB.NET.

Many thanks

Kadj

micharl · May 5th, 2008, 04:26 AM

Same problem here. But I need it in VB6 format. Please advise...

Komila · May 17th, 2008, 06:30 AM

hi...
the code is as belo.
but be sure that u have to make a datagrid for this.

        Response.ContentType = "application/vnd.ms-excel"
        ' Remove the charset from the Content-Type header.
        Response.Charset = ""
        ' Turn off the view state.
        Page.EnableViewState = False
        Dim tw As System.IO.StringWriter
        tw = New System.IO.StringWriter
        Dim hw As HtmlTextWriter = New HtmlTextWriter(tw)
        'Get the HTML for the control.
        Me.DataGrid2.RenderControl(hw)
        ' Write the HTML back to the browser.

        Response.Write(tw.ToString)
        'cn1.Close()
        'End the response.
        Response.End()

Komila Kalia
Software Developer
Reliance engineering Associates (P) Ltd.