如果将最后一页按钮代码放在If（！this.isPostBack）内，则可以正常工作，因此我进行了大量研究以尝试了解导致问题的原因，但无法找出我的具体问题，请仔细阅读有关此问题的所有主题stackoverflow也是如此，但是没有运气。我想念什么？
另外，我无法使Excel导出正常工作，我尝试了3种不同的方法，所有这些方法均导致OutOfMemoryException，但最新的方法仍在该方法中，但已作了进一步的评论。
http://i.imgur.com/uoyIhdB.jpg
ASPX代码
<%@ Page Language="C#" AutoEventWireup="true"
CodeBehind="TestWebFormView.aspx.cs" Inherits="NameSpace.TestWebFormView"
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<%--Form--%>
<form id="form1" runat="server" visible="true">
<asp:Hidden
<div>
<%--GridView--%>
<asp:GridView ID="GridView" AllowPaging="true" PageSize="5" OnPageIndexChanging="GridView_PageIndexChanging" runat="server" AutoGenerateColumns="true" DataKeyNames="Column1, Column2, Column3, Column4, Column5, Column6, Column7, Column8, Column9, Column10, Column11, Column12, Column13, Column14"></asp:GridView>
<%--Last Page Button(Not done, Datagrid vanishes on click, Last Page & Export button remain in browser view)--%>
<asp:Button ID="btnLastPage" runat="server" Text="Jump to last page" OnClick="btnLastPage_Click" />
<%--Export Button (Not done, OutOfMemoryException, need to somehow divide the workload - Stored Proc in the SQL back end behind the components maybe)--%`>`
<asp:Button ID="btnExport" runat="server" Text="Exp to Excel" OnClick="btnExport_Click"/>
</div>
</form>
</body>
</html>
后面的代码
using System;
using DBComponentsLibrary;
using DBComponentsLibrary.NameDataSetTableAdapters;
using System.Web.UI.WebControls;
using System.IO;
using System.Web.UI;
using System.Drawing;
namespace Name
{
public partial class TestWebFormView : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
loadGridData();
}
private void loadGridData()
{
NameTableAdapter TA = new NameTableAdapter();
NameDataSet rds = new NameDataSet();
NameDataSet.NameDataTable Rdt = new NameDataSet.NameDataTable();
TA.Fill(Rdt);
GridView.DataSource = Rdt;
GridView.DataBind();
GridView.Rows[0].Cells[0].Visible = true;
}
protected void GridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView.PageIndex = e.NewPageIndex;
Page.DataBind();
}
protected void btnLastPage_Click(object sender, EventArgs e)
{
int myNewIndex = GridView.PageCount - 1;
if (myNewIndex != null && myNewIndex != -1 && myNewIndex < GridView.PageCount)
{
GridView.PageIndex = myNewIndex;
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
}
// //Response.Buffer = true;
// //Response.Charset = "";
// //Response.BinaryWrite(Bytes);
// Response.ClearHeaders();
// Response.Clear();
// Response.AddHeader("content-disposition", "attachment;filename=*.xls");
// Response.ContentType = "application/vnd.ms-excel";
// Response.End();
// using (StringWriter sw = new StringWriter())
// {
// HtmlTextWriter hw = new HtmlTextWriter(sw);
// //To Export all pages
// //GridView.AllowPaging = true;
// this.DataBind();
// //this.BindGrid();
// GridView.HeaderRow.BackColor = Color.White;
// foreach (TableCell cell in GridView.HeaderRow.Cells)
// {
// cell.BackColor = GridView.HeaderStyle.BackColor;
// }
// foreach (GridViewRow row in GridView.Rows)
// {
// row.BackColor = Color.White;
// foreach (TableCell cell in row.Cells)
// {
// if (row.RowIndex % 2 == 0)
// {
// cell.BackColor = GridView.AlternatingRowStyle.BackColor;
// }
// else
// {
// cell.BackColor = GridView.RowStyle.BackColor;
// }
// cell.CssClass = "textmode";
// }
// }
// GridView.RenderControl(hw);
// //style to format numbers to string
// string style = @"<style> .textmode { } </style>";
// Response.Write(style);
// Response.Output.Write(sw.ToString());
// Response.Flush();
// Response.End();
// }
//}
}
}
编辑2016-02-17：编辑并清理代码。还有一些我要修复的错误。但是发展正在前进。如果我被某些特定的东西卡住了，我会发表一篇新文章。再次感谢！
问题在于，您正在将页码设置为In32类型可以表示的最高编号。
protected void btnLastPage_Click(object sender, EventArgs e)
{
GridView.PageIndex = Int32.MaxValue;
DataBind();
}
那应该是
protected void btnLastPage_Click(object sender, EventArgs e)
{
GridView.PageIndex = GridView.PageCount - 1;
DataBind();
}
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句