我写了一个导出,导出的名字是中文字,如果写个英文字就不是乱码,代码如下:public void Bind()
{
string sql = "select * from userInfo";
DataTable dt = SQLServerDAL.DbHelperSQL.Query(sql).Tables[0];
StringWriter sw = new StringWriter();
sw.WriteLine("编号\t姓名\t年龄");
foreach(DataRow dr in dt.Rows)
{
sw.WriteLine(dr["id"] + "\t" + dr["name"] + "\t" + dr["age"]);
}
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AddHeader("Content-Disposition", "attachment; filename=报表.xls");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End(); }
请问各位前辈要怎么解决呀!
{
string sql = "select * from userInfo";
DataTable dt = SQLServerDAL.DbHelperSQL.Query(sql).Tables[0];
StringWriter sw = new StringWriter();
sw.WriteLine("编号\t姓名\t年龄");
foreach(DataRow dr in dt.Rows)
{
sw.WriteLine(dr["id"] + "\t" + dr["name"] + "\t" + dr["age"]);
}
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AddHeader("Content-Disposition", "attachment; filename=报表.xls");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End(); }
请问各位前辈要怎么解决呀!
解决方案 »
- [RadioButtonList绑定数据源问题]
- VS2005发布问题
- 本人第一次在本机上搭建asp.net的一个tourEx的旅游站点注册出错了,帮忙看看
- 谁有好看的asp.net theme?
- 如何在cs文件中弹出提示框???
- asp.net上传大文件的问题
- ◇关于URL中传递参数的问题,请高手解答◇
- 用SmtpMail发送邮件出现问题,帮忙解决一下,谢谢!
- 如何用asp.net实现asp中的request.form("name")?
- code first Add-Migration
- 请问HttpContext.Current.User是保存在哪的?
- GridView分页问题(翻页时不重新绑定数据源)
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
{
string sql = "select * from userInfo";
DataTable dt = SQLServerDAL.DbHelperSQL.Query(sql).Tables[0];
StringWriter sw = new StringWriter();
sw.WriteLine("编号\t姓名\t年龄");
foreach(DataRow dr in dt.Rows)
{
sw.WriteLine(dr["id"] + "\t" + dr["name"] + "\t" + dr["age"]);
}
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment; filename="+UrlPathEncode("报表.xls"));
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-7");
Response.ContentType = "application/ms-excel";
Response.Write(sw);
Response.End(); }
HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString();或者GB2312
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AddHeader("Content-Disposition", "attachment; filename=报表.xls");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
这里你设置两次编码,最终输出的gb2312,看下浏览器里用的什么编码,改成gb2312可能就不乱了,或者用utf-8试试