csv datatable 乱码 导出_Asp.NET中把DataTable导出为Excel ，中文有乱码现象解决办法...

//DataTable为要导出的数据表

DataGrid dg = new DataGrid();

dg.DataSource = DataTable;

dg.DataBind();

//如果文件名称有中文，指定编码

string fileName = HttpUtility.UrlEncode("JobHistoryList", Encoding.UTF8).ToString();

//设置编码格式

HttpContext.Current.Response.Clear();

HttpContext.Current.Response.Charset = "UTF-8";// "UTF-8"或者"GB2312"

HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";//text/csv

HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;

HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName + ".xls");

//导出excel

System.IO.StringWriter oSW = new System.IO.StringWriter();

HtmlTextWriter oHW = new HtmlTextWriter(oSW);

dg.RenderControl(oHW);

//输出时加上""解决编码问题

//返回浏览器，

HttpContext.Current.Response.Write("" + oSW.ToString());

HttpContext.Current.Response.End();

原文：http://www.cnblogs.com/johnblogs/p/6112892.html