using System.IO;//命名空间
//在page中加入EnableEventValidation = "false"
protected void Button2_Click(object sender, EventArgs e)
{GridView1.AllowPaging = false;//关闭分页功能
bd(0);
ExcelOut(GridView1);//调用方法
GridView1.AllowPaging = true;//打开分页功能重新绑回gridview中
bd(0);
}
public void ExcelOut(GridView gv)
{//导出Excel表的方法
if (gv.Rows.Count > 0)
{//有数据行
Response.Clear();
Response.ClearContent();
Response.AddHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");//以系统时间设置为文件名
Response.ContentEncoding = System.Text.Encoding.UTF8;//UTF8编码
Response.ContentType = "application/ms-excel";//文件类型
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);
Response.Write(sw.ToString());
Response.Flush();
Response.End();//结束
}
else
{
Response.Write("没有数据记录");
}
}
public override void VerifyRenderingInServerForm(Control control)//必须有这个方法(就是个空方法)
{ }