GV导出到Excel

来源:互联网 发布:炽焰帝国2捏脸数据 编辑:程序博客网 时间:2024/04/20 05:15
//这句话必须,否则出现异常:类型“GridView”的控件“XXXX”必须放在具有 runat=server 的窗体标记内
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();
}
0 0
原创粉丝点击