[問題] asp.net gridview 匯出到excel 分頁失效

看板Web_Design作者evan1112 (麻辣小雞)時間16年前 (2010/01/05 16:01)推噓1(1推 0噓 3→)

留言4則, 2人參與討論串1/1

板上的大大，我做一個網頁，需要將gridview的資料匯出到excel 爬了很多文，網頁也快被我改爛了，gridview allowpaging功能完全出不來不知道哪裡出錯了，請各位大大幫忙了，以下是有關這個功能的程式碼。 public override void VerifyRenderingInServerForm(Control control) { // Confirms that an HtmlForm. control is rendered for } protected void BtnExport_Click(object sender, EventArgs e) { Response.Clear(); Response.Buffer = true; Response.Charset = "";//以Content-Type Header中去除Charset設置 Response.Write("<meta http-equiv=Content-Type content=text/html;charset=utf-8>"); Response.AddHeader("content-disposition", "attachment;filename=FileName.xls"); Response.ContentType = "application/vnd.ms-excel";//內容類型為Excel System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); EnableViewState = false; //關閉ViewState //關閉換頁跟排序 GridView1.AllowPaging = false; //移去不要的欄位 //GridView1.Columns.RemoveAt(GridView1.Columns.Count - 1); //GridView1.DataBind(); //GridView1.Columns.RemoveAt(3); //移去不要的欄位如新增修改刪除 IUD//第一欄 // BindData(); this.GridView1.RenderControl(htmlWrite); //取的Control的HTML Response.Write(stringWrite.ToString());//把HTML寫回Browser Response.Flush(); Response.End(); //匯出後再將分頁開啟 GridView1.AllowPaging = true; } protected void paging(object sender, GridViewPageEventArgs e) { GridView1.PageIndex = e.NewPageIndex; //BindData(); } -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 163.15.161.238