关于datagirdview 导出excel乱码问题

C# code

    public static void ExportExcel(GridView gridview,string filename,DataBindGridView databindgridview)    {        HttpContext.Current.Response.Clear();        HttpContext.Current.Response.Buffer = true;        HttpContext.Current.Response.Charset = "GB2312";        HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");        //System.Text.Encoding.GetEncoding("GB2312")        //HttpContext.Current.Response.AppendHeader("content-disposition", "attachment;filename=\"" + System.Web.HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8) + ".xls\"");        // 如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码！！！        HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8"); //System.Text.Encoding.GetEncoding("GB2312");//System.Text.Encoding.UTF8;        HttpContext.Current.Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。         //System.IO.StringWriter oStringWriter = new System.IO.StringWriter();        gridview.EnableViewState = false;        //this.EnableViewState = false;        System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);//：中国        System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);        databindgridview();        gridview.RenderControl(oHtmlTextWriter);        HttpContext.Current.Response.Output.Write(oStringWriter.ToString());        HttpContext.Current.Response.Flush();        HttpContext.Current.Response.End();    }

这个是代码，导出来中文是乱码，网上的解决办法我也用了，可是还是乱码请教大虾们，代码哪里有误吗？

[解决办法]
HttpContext.Current.Response.Charset = "GB2312";HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");

这两个值统一一下，试试呢？
[解决办法]

探讨

C# code
public static void ExportExcel(GridView gridview,string filename,DataBindGridView databindgridview)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Respons……

[解决办法]
全部用utf-8就可以了
[解决办法]

C# code

 //System.Text.Encoding.GetEncoding("GB2312")        //HttpContext.Current.Response.AppendHeader("content-disposition", "attachment;filename=\"" + System.Web.HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8) + ".xls\"");        // 如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码！！！
[解决办法]
探讨


引用:

C# code
//System.Text.Encoding.GetEncoding("GB2312")
//HttpContext.Current.Response.AppendHeader("content-disposition", "attachment;filename=\"" + System.Web.HttpUtility.UrlEncode(f……

[解决办法]
我这里有多种解决方案，你可以选择自己合适的方法。代码如下：
1、由dataset生成

以下为引用的内容：
public void CreateExcel(DataSet ds,string typeid,string FileName)

  {

  HttpResponse resp;

  resp = Page.Response;

  resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); 
 

  resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName); 

  string colHeaders= "", ls_item="";

  int i=0;

  //定义表对象与行对像，同时用DataSet对其值进行初始化

  DataTable dt=ds.Tables[0];

  DataRow[] myRow=dt.Select("");

  // typeid=="1"时导出为EXCEL格式文件；typeid=="2"时导出为XML格式文件

  if(typeid=="1")

   {

   //取得数据表各列标题，各标题之间以"t分割，最后一个列标题后加回车符

   for(i=0;i     colHeaders+=dt.Columns[i].Caption.ToString()+""t";

   colHeaders +=dt.Columns[i].Caption.ToString() +""n"; 

   //向HTTP输出流中写入取得的数据信息

   resp.Write(colHeaders);

   //逐行处理数据  

   foreach(DataRow row in myRow)

    {

    //在当前行中，逐列获得数据，数据之间以"t分割，结束时加回车符"n

    for(i=0;i      ls_item +=row[i].ToString() + ""t";   

    ls_item += row[i].ToString() +""n";

    //当前行数据写入HTTP输出流，并且置空ls_item以便下行数据  

    resp.Write(ls_item);

    ls_item="";

   }

  }

  else

   {

   if(typeid=="2")

    {

    //从DataSet中直接导出XML数据并且写到HTTP输出流中

    resp.Write(ds.GetXml());

   }  

  }

  //写缓冲区中的数据到HTTP头文件中

  resp.End();

 }