GridView导出Execl 及 乱码

protected void Page_Load(object sender, EventArgs e)
...{
　if (!Page.IsPostBack)
　...{
　　BindData();
　}
}
private void BindData()
...{
　string query = "SELECT * FROM customers";
　SqlConnection myConnection = new SqlConnection(ConnectionString);
　SqlDataAdapter ad = new SqlDataAdapter(query, myConnection);
　DataSet ds = new DataSet();
　ad.Fill(ds, "customers");
　GridView1.DataSource = ds;
　GridView1.DataBind();
}

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

protected void Button1_Click(object sender, EventArgs e)
...{
　Response.Clear();
　Response.AddHeader("content-disposition","attachment;filename=FileName.xls");
　Response.Charset = "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();
}
protected void paging(object sender,GridViewPageEventArgs e)
...{
　GridView1.PageIndex = e.NewPageIndex;
　BindData();
}  

 

 

在上面的代码中，我们首先将gridview绑定到指定的数据源中，然后在button1的按钮（用来做导出到EXCEL的）的事件中，写入相关的代码。这里使用Response.AddHeader("content-disposition","attachment;filename= exporttoexcel.xls");中的filename来指定将要导出的excel的文件名，这里是exporttoexcel.xls。要注意的是，由于gridview的内容可能是分页显示的，因此，这里在每次导出excel时，先将gridview的allowpaging属性设置为 false,然后通过页面流的方式导出当前页的gridview到excel中，最后再重新设置其allowpaging属性。另外要注意的是，要写一个空的VerifyRenderingInServerForm方法（必须写），以确认在运行时为指定的ASP.NET 服务器控件呈现HtmlForm 控件。

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/vincent0203/archive/2008/03/28/2225135.aspx

 

 

注：以上方法可能会出现乱码，现方法改为：

　　protected void Page_Load(object sender, EventArgs e)
        {
            BindData();
        }
        protected void BindData()
        {
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                DataTable dt = new DataTable();
                SqlDataAdapter da = new SqlDataAdapter("select * from G_B_Worker", conn);
                da.Fill(dt);
                gvInfo.DataSource = dt;
                gvInfo.DataBind();
            }
        }
        protected void btnExport_Click(object sender, EventArgs e)
        {
            Response.Clear();
            Response.Buffer = false;
            Response.Charset = "GB2312";
            Response.AppendHeader("Content-Disposition", "attachment;filename=pkmv_de.xls");
            Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            Response.ContentType = "application/ms-excel";
            Response.Write("<meta http-equiv=Content-Type content=\"text/html; charset=GB2312\">");
            this.EnableViewState = false;
            System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
            HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);
            gvInfo.RenderControl(oHtmlTextWriter);
            Response.Write(oStringWriter.ToString());
            Response.End();
        }
        public override void VerifyRenderingInServerForm(Control control)
        {

        }