一段代码，关于手写分页程序的，请看看哪里有问题~20分表心意

Question

前台：<form runat="server">
共有<asp:Label id="lblRecordCount" ForeColor="red" runat="server" />条记录     
当前为<asp:Label id="lblCurrentPage" ForeColor="red" runat="server" />/<asp:Label id="lblPageCount" ForeColor="red" runat="server" />页 <asp:LinkButton id="lbnPrevPage" Text="上一页" CommandName="prev" OnCommand="Page_OnClick" runat="server" />
<asp:LinkButton id="lbnNextPage" Text="下一页" CommandName="next" OnCommand="Page_OnClick" runat="server" /></form>后台： private void Page_Load(Object sender, EventArgs e)
{
PageSize = 10;
if(!IsPostBack)
{
CreateLabel(CreateTable());
     CurrentPage = 0;
     ViewState["PageIndex"] = 0;
     RecordCount = sum();
lblRecordCount.Text = RecordCount.ToString();
    PageCount = RecordCount / PageSize + 1;
lblPageCount.Text = PageCount.ToString();
     ViewState["PageCount"] = PageCount;
}
}
}    public int sum()
    {
OleDbConnection conn=new OleDbConnection(ConfigurationSettings.AppSettings["data"]+Server.MapPath(ConfigurationSettings.AppSettings["path"])); 
conn.Open();
        int intCount;
        string strCount = "select count(*) from aa";
        OleDbCommand comm = new OleDbCommand(strCount, conn);
        intCount = Convert.ToInt32(comm.ExecuteScalar());
        return intCount;
    }    ICollection CreateSource()
    {
        int StartIndex;
        StartIndex = CurrentPage * PageSize;
        CreateLabel(CreateTable()); 
    }    public void Page_onClick(Object sender, CommandEventArgs e)
    {
        CurrentPage = (int)ViewState["PageIndex"];
        PageCount = (int)ViewState["PageCount"];
        string cmd = e.CommandName;
        switch (cmd)
        {
            case "next":
                if (CurrentPage < (PageCount - 1)) CurrentPage++;
                break;
            case "prev":
                if (CurrentPage > 0) CurrentPage--;
                break;
        }
        ViewState["PageIndex"] = CurrentPage;
        CreateLabel(CreateTable()); 
    } public DataTable CreateTable()
    {
OleDbConnection conn=new OleDbConnection(ConfigurationSettings.AppSettings["data"]+Server.MapPath(ConfigurationSettings.AppSettings["path"])); 
conn.Open();
string sql="select * FROM aa";
OleDbDataAdapter da=new OleDbDataAdapter(sql,conn);
DataTable dt=new DataTable();
da.Fill(dt, StartIndex, PageSize, "aa");
lbnNextPage.Enabled = true;
     lbnPrevPage.Enabled = true;
     if(CurrentPage==(PageCount-1)) lbnNextPage.Enabled = false;
     if(CurrentPage==0) lbnPrevPage.Enabled = false;
     lblCurrentPage.Text = (CurrentPage+1).ToString();
return dt;
    } public void CreateLabel(DataTable dt)
{
StringBuilder sb = new StringBuilder();
sb.Append("<TABLE id='Table1' style='Z-INDEX: 102; LEFT: 8px; POSITION: absolute; TOP: 8px' cellSpacing='1' cellPadding='1' width='300' border='1'>");
for(int i = 0;i < dt.Rows.Count ; i++)
{
sb.Append("<tr>");
for(int j = 0 ;j < dt.Columns.Count; j ++)
{
sb.Append("<td>");
sb.Append(dt.Rows[i][j].ToString());
sb.Append("</td>");
}
sb.Append("</tr>");
}
sb.Append("</table>");
this.Response.Write(sb);
}

Answer 1

private void Page_Load(Object sender, EventArgs e)
{
PageSize = 10;
if(!IsPostBack)
{
CreateLabel(CreateTable());
    CurrentPage = 0;
    ViewState["PageIndex"] = 0;
    RecordCount = sum();
lblRecordCount.Text = RecordCount.ToString();
   PageCount = RecordCount / PageSize + 1;
lblPageCount.Text = PageCount.ToString();
    ViewState["PageCount"] = PageCount;
}
}
}
去掉最后一个｝

Answer 2

up
  
－－－－－－－－－－－－－－－－－－－－－－－－
个人blog(http://blog.csdn.net/shixin1198)欢迎访问

Answer 3

up
  
－－－－－－－－－－－－－－－－－－－－－－－－
个人blog(http://blog.csdn.net/shixin1198)欢迎访问