private void EstablishCSV(DataTable dt)
{
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".csv");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
Response.ContentType = "application/excel";
StringBuilder sb = new StringBuilder();
string s;
//Write Field Title
s = "";
foreach (DataColumn dc in dt.Columns)
{
s += dc.ColumnName + ",";
}
s = s.Substring(0, s.Length - 1)+"\r\n";
sb.Append(s);
//Write Row
foreach (DataRow dr in dt.Rows)
{
s = "";
foreach (object o in dr.ItemArray)
{
s += o.ToString()+",";
}
s = s.Substring(0, s.Length - 1) + "\r\n";
sb.Append(s);
}
Response.Write(sb.ToString());
Response.End();
}
C#(WEB)DataTable输出CSV文件(通用函数)
最新推荐文章于 2024-06-12 09:46:16 发布