it outsourcing, web programming, emarketing, econsulting, it consultant, internet consultant, we knows all about internet

March 14, 2010

.net acces Ajax Ajuntament ASP asp.net c# css CSS2 Enterprise export globaria google gridview hibernate mapping hotel jquery linux mallorca Mamacarter Maquetación massimo estudio melia mysql Php Planeta Web SEO share files trivia XHTML

Contact us

If you have any doubt or suggestion, you may contact us with the next form:

This field is required.

Please enter a valid email.

How did you hear about us? Google Other Advertising Friend's recomendation Third party site Yahoo Comment

This field is required.

This example is very easy to implement. We only need to put the next code in the desired button:

protected void btnExportCSV_Click(object sender, EventArgs e)
{
    Response.Clear();
    Response.Buffer = true;
    Response.AddHeader("content-disposition",
     "attachment;filename=GridViewExport.csv");
    Response.Charset = "";
    Response.ContentType = "application/text";

    GridView1.AllowPaging = false;
    GridView1.DataBind();

    StringBuilder sb = new StringBuilder();

    //iloop through the columns
    for (int k = 0; k < GridView1.Columns.Count; k++)
    {
        //append a separator
        sb.Append(GridView1.Columns[k].HeaderText + ',');
    }

    //append a new line
    sb.Append("\r\n");

    //loop through the rows
    for (int i = 0; i < GridView1.Rows.Count; i++)
    {
        for (int k = 0; k < GridView1.Columns.Count; k++)
        {
            //append a separator
            sb.Append(GridView1.Rows[i].Cells[k].Text + ',');
        }

        //append a new line
        sb.Append("\r\n");
    }

    Response.Output.Write(sb.ToString());
    Response.Flush();
    Response.End();
}

Hope you find this helpful Good bye

Tags: asp.net, export, csv, gridview

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

Add comment
Write your comment
This field is required.	Please enter a valid email.
Comment This field is required.
Security code:	Enter code: