C#中将控件数据导出Excel

在asp.net项目中的一个把数据 导出Excel表格的小事件如下：
 protected void ibnOut_Click(object sender, ImageClickEventArgs e)//导出Excel按钮的点击事件
        {
              GridView2.DataSource = dt;//dt是查询出的结果集
                GridView2.DataBind();
                Response.Clear();
                Response.Buffer = true;
                Response.Charset = "UTF-8";
                Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
                Response.ContentEncoding = System.Text.Encoding.UTF8;
                Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
                GridView2.Visible = true;//设置成true才能显示写出 标记A
                System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
                System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
                this.GridView2.RenderControl(oHtmlTextWriter);