Export DataTable to CSV/Excel

HttpContext context = HttpContext.Current;

context.Response.Clear();

foreach (DataColumn column in dataTable.Columns)

{

    context.Response.Write(column.ColumnName + ",");

}

context.Response.Write(Environment.NewLine);

foreach (DataRow row in dataTable.Rows)

{

    for (int i = 0; i < dataTable.Columns.Count; i++)

    {

        context.Response.Write(row[i].ToString() + ",");

    }

    context.Response.Write(Environment.NewLine);

}

context.Response.ContentType = "text/csv";

context.Response.AppendHeader("Content-Disposition", "attachment; filename=" + fileName + ".csv");

context.Response.End();

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.IO;

using System.Data;

public partial class _Default : System.Web.UI.Page 

{

    protected void Page_Load(object sender, EventArgs e)

    { }

    protected void Button1_Click(object sender, EventArgs e)

    {

        DataSet ds = new DataSet();

        ds.ReadXml(Server.MapPath("Products.xml"));

        ExportToExcel(ds.Tables[0], "DataTable");

    }

    protected void ExportToExcel(DataTable dataTable, string fileName)

    {

        HttpContext context = HttpContext.Current;

        context.Response.Clear();

        foreach (DataColumn column in dataTable.Columns)

        {

            context.Response.Write(column.ColumnName + ",");

        }

        context.Response.Write(Environment.NewLine);

        foreach (DataRow row in dataTable.Rows)

        {

            for (int i = 0; i < dataTable.Columns.Count; i++)

            {

                context.Response.Write(row[i].ToString() + ",");

            }

            context.Response.Write(Environment.NewLine);

        }

        context.Response.ContentType = "text/csv";

        context.Response.AppendHeader("Content-Disposition", "attachment; filename=" + fileName + ".csv");

        context.Response.End();

    }

}