软件下载 | 资讯教程 | 最近更新 | 下载排行 | 一键转帖 | 发布投稿
您的位置:最火下载站 > 网络编程 > ASP.NET > Asp.net 解决导出到CSV文件乱码的问题

Asp.net 解决导出到CSV文件乱码的问题

string name = System.Configuration.ConfigurationSettings.AppSettings["downloadurl"].ToString();
FileStream fs = new FileStream(name, FileMode.Create, FileAccess.Write);
StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.GetEncoding("gb2312"));

sw.WriteLine(" 自动编号,姓名,年龄");
foreach (DataRow dr in dt.Rows)
{
    sw.WriteLine(dr["ID"] + "," + dr["vName"] + "," + dr["iAge"]);
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(name));
Response.ContentType = "application/ms-excel";// 指定返回的是一个不能被客户端读取的流,必须被下载
Response.WriteFile(name); // 把文件流发送到客户端
Response.End();

重点为红色标记处! 

 ------

string strFile = "FileName" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".csv";

        //这一部分替换为你从DataTable/GridView获取的内容
        StringBuilder sb = new StringBuilder();
        sb.AppendLine("id,name");
        sb.AppendLine("1,邹俊才");
        sb.AppendLine("2,才俊邹");
        sb.AppendLine("3,Jon");

        StringWriter sw = new StringWriter(sb);
        sw.Close();

        Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", strFile));
        Response.Charset = "gb2312";
        Response.ContentType = "application/ms-excel";
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
        Response.Write(sw);
        Response.Flush();
        Response.End();

    相关阅读
    网友评论
    栏目导航
    推荐软件