Wrox Programmer Forums
|
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 18th, 2006, 08:31 AM
Registered User
 
Join Date: Sep 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Exporting Gridview to CSV

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
 
Old May 5th, 2008, 04:26 AM
Registered User
 
Join Date: May 2008
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old May 17th, 2008, 06:30 AM
Authorized User
 
Join Date: Jun 2006
Posts: 47
Thanks: 0
Thanked 2 Times in 2 Posts
Default

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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting a Datagrid to a CSV file pauljohns353 Visual Basic 2005 Basics 1 November 21st, 2006 04:56 PM
Exporting a DataGrid to a CSV - VB.net pauljohns353 Visual Studio 2005 0 October 19th, 2006 08:46 AM
Exporting to CSV smajumdar_82 Access VBA 1 July 10th, 2006 10:38 AM
Exporting Report to CSV format. chakravarthy_vr Reporting Services 4 March 20th, 2006 07:27 AM
exporting to csv format dazednconfused Beginning PHP 1 July 11th, 2003 03:31 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.