SqlConnClass connClass = new SqlConnClass(); DataTable dt = connClass.GetQrCodeDetails(); Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment;filename=DataTable.csv"); Response.Charset = ""; Response.ContentType = "application/text"; StringBuilder sb = new StringBuilder(); for (int k = 0; k < dt.Columns.Count; k++) { //add separator sb.Append(dt.Columns[k].ColumnName + ','); } //append new line sb.Append("\r\n"); for (int i = 0; i < dt.Rows.Count; i++) { for (int k = 0; k < dt.Columns.Count; k++) { //add separator sb.Append(dt.Rows[i][k].ToString().Replace(",", ";") + ','); } //append new line sb.Append("\r\n"); } Response.Output.Write(sb.ToString()); Response.Flush(); Response.End();
Response.Charset = "";
text/csv
DataTable
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)