GridView 分页导出Excel

一、GridView  分页

允许分页  AllowPaging = True；PageSize设置每页条数，默认是10条

设置分页的样式 PagerSetting节点里的属性。

GridView1.PagerSettings.Mode = PagerButtons.NextPreviousFirstLast;
GridView1.PagerSettings.NextPageImageUrl = "img/next.gif";
GridView1.PagerSettings.PreviousPageImageUrl = "img/pre.gif";
GridView1.PagerSettings.FirstPageImageUrl = "img/first.gif";
GridView1.PagerSettings.LastPageImageUrl = "img/last.gif";

添加OnPageIndexChanged(object sender, EventArgs e){BindData();},OnPageIndexChanging(object sender, GridViewPageEventArgs e){GridView1.PageIndex = e.NewPageIndex;

}事件;

添加当前页和总页数GridView1_DataBound(object sender, EventArgs e)
    {
        //添加分页码显示
        GridViewRow bottomPagerRow = GridView1.BottomPagerRow;
        Label bottomLabel = new Label();
        bottomLabel.Text = "目前所在分页：（" + (GridView1.PageIndex + 1) + "/" + GridView1.PageCount + "）";
        bottomPagerRow.Cells[0].Controls.Add(bottomLabel);
    }

二、GridView导出Excel

导出有分页的GirdView的所有页数据

public void ExportToExcel(Control ctrl, String FileName)
       {
           GridView gv = (GridView)ctrl;
           gv.AllowPaging = false;//清除分页
           gv.AllowSorting = false;// 清除排序
           BindGVCXData();
           HttpContext.Current.Response.Charset = "GB2312";
           HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
           HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);
           HttpContext.Current.Response.ContentType = "application/ms-excel";
           HttpContext.Current.Response.Write("");
           StringWriter tw = new StringWriter();
           HtmlTextWriter hw = new HtmlTextWriter(tw);
           gv.RenderControl(hw);
           HttpContext.Current.Response.Write(tw.ToString());
           HttpContext.Current.Response.End();
           gv.AllowSorting = true; //恢复分页
           gv.AllowPaging = true; //恢复排序
           BindGVCXData(); //再次绑定
       }