将GridView导出到Excel并防止内容乱码

我在数据库中建一个proc_ViewDriverDicpatch的储存过程，该储存过程主要完成对数据表进行交叉数据，完成交叉表功能，调用过程如下：

 

    public void BindData()
    ...{
        Yesidea.DAO.DbHelperSQL dbhelper = new Yesidea.DAO.DbHelperSQL(new Yesidea.DAO.BaseDAO());
        SqlParameter[] parameters = ...{
                    new SqlParameter("@TableName", SqlDbType.VarChar,50),
                    new SqlParameter("@纵轴", SqlDbType.VarChar,50),
                    new SqlParameter("@横轴", SqlDbType.VarChar,50),
                    new SqlParameter("@表体内容", SqlDbType.VarChar,20),
                    new SqlParameter("@是否加横向合计", SqlDbType.Bit),
                    new SqlParameter("@是否加纵向合计", SqlDbType.Bit)};
        parameters[0].Value = "ViewDicpatchDriver";
        parameters[1].Value = "dname";
        parameters[2].Value = "udept";
        parameters[3].Value = "mileage";
        parameters[4].Value = 1;
        parameters[5].Value = 1;
        DataSet ds = dbhelper.RunProcedure("proc_ViewDriverDicpatch", parameters, "ViewDicpatchDriver");
        this.GridView1.DataSource = ds;
        this.GridView1.DataBind();
        this.GridView1.HeaderRow.Cells[0].Text = "司机姓名\部门";
    }

输出为 Excel并防止文件内容乱码的代码如下：

    protected void btnExport_Click(object sender, EventArgs e)
    ...{
        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename="" + Server.UrlEncode("FileName.xls") + "");
        Response.Charset = "GB2312";
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
        Response.ContentType = "application/vnd.xls";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

        GridView1.AllowPaging = false;
        BindData();
        GridView1.RenderControl(htmlWrite);

        Response.Write(stringWrite.ToString());
        Response.End();
        GridView1.AllowPaging = true;
        BindData();
    }

注意：在页面中千万别忘了添加如下代码。

 

    public override void VerifyRenderingInServerForm(Control control)
    ...{
        // Confirms that an HtmlForm control is rendered for
    }