ASP.NET GridView保存数据到Excel

         此代码加到服务器端，不然会报错：       

           public override void VerifyRenderingInServerForm(Control control)
           { 
                      //base.VerifyRenderingInServerForm(control);
           }

                 // GridView1.AllowPaging = false; //清除分页
           // GridView1.AllowSorting = false; //清除排序     
            Button1_Click(sender, e); //绑定gridview1数据源的函数。
            Response.Clear();
            Response.Charset = "UTF-8";  //UTF-8支持繁体中文，简体中文请用GB2312
            Response.AppendHeader("Content-Disposition", "attachment;filename=mes.xls");//保存为mes.xls    

            Response.ContentEncoding = Encoding.GetEncoding(65001);
            Response.ContentType = "application/ms-excel";      //设置输出文件类型为excel文件。   
            StringWriter oStringWriter = new StringWriter();
            HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);
            GridView1.RenderControl(oHtmlTextWriter);
            Response.Output.Write(oStringWriter.ToString());
            Response.Flush();
            Response.End();
         // GridView1.AllowSorting = true; //恢复分页         
         // GridView1.AllowPaging = true;  //恢复排序
            Button1_Click(sender, e); //再次绑定gridview1数据源的函数