Tuesday, July 14, 2009

Export Data From dataTable to csv file and save to local PC

public static void ExportDataToCSVFile(string filename, DataTable getExportData)
{
DataTable toCSVFile = getExportData.Copy();
HttpContext context = HttpContext.Current;
context.Response.Clear();

foreach (DataColumn column in toCSVFile.Columns)
{
context.Response.Write(column.ColumnName + ",");
}

context.Response.Write(Environment.NewLine);
foreach (DataRow row in toCSVFile.Rows)
{
for (int i = 0; i < toCSVFile.Columns.Count; i++)
{
context.Response.Write(row[i].ToString().Replace(",", string.Empty) + ",");
}

context.Response.Write(Environment.NewLine);
}

context.Response.ContentType = "text/csv";
context.Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + ".csv");
context.Response.End();
}

No comments: