Question

为什么我导出的数据是乱码？

ds = d.GetDataSet(sql); GridView dg_xls = new GridView(); dg_xls.DataSource = ds.Tables[0]; dg_xls.DataBind(); Response.Clear(); Response.Buffer = false; HttpContext.Current.Response.Charset = "UTF-8"; //设置编码的 HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8; HttpContext.Current.Response.ContentType = "application/ms-excel"; HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=temp.xls"); Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8"); System.IO.StringWriter tw = new System.IO.StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(tw); dg_xls.RenderControl(hw); HttpContext.Current.Response.Write(tw.ToString()); HttpContext.Current.Response.End();

Answer 1

首先要检查数据库里面是否是乱码，如果不是在看数据库的编码和你设置的编码是否一致，不一致也会产生读取时乱码。 如果都没问题用的是servlet应用的话可以写个过滤器 乱码问题一般都是这样解决的