此代码加到服务器端,不然会报错:
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数据源的函数