博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

一、预览效果



二、前台控件呈现部分

<asp:repeater id="LeaveMessage" runat="server" >
<ItemTemplate>
<table width="100%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#D4D0C8">
<tr>
<td width="85%" bgcolor="#FFFAFF"><div align="left"><%#DataBinder.Eval(Container.DataItem, "sNewsTitle")%></div></td>
<td width="15%" bgcolor="#FFFAFF" align="left"><%#DataBinder.Eval(Container.DataItem, "dAddTime")%></td>
</tr>
</table>
<hr size="3px" width="90%"/>
</ItemTemplate> 
</asp:repeater>
共有
<asp:Literal ID="RecordCount" runat="server"></asp:Literal>条记录
共有
<asp:Literal ID="PageCount" runat="server"></asp:Literal>
当前第
<asp:Literal ID="Pageindex" runat="server"></asp:Literal>
<asp:HyperLink ID="FirstPage" runat="server" Text="首页"></asp:HyperLink>
<asp:HyperLink ID="PrevPage" runat="server" Text="上一页"></asp:HyperLink>
<asp:HyperLink ID="NextPage" runat="server" Text="下一页"></asp:HyperLink>
<asp:HyperLink ID="LastPaeg" runat="server" Text="尾页"></asp:HyperLink>
跳转到
<asp:Literal ID="Literal1" runat="server"></asp:Literal>

三、后置代码部分(CS代码)
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Text;

public partial class admin_LeaveMessages : System.Web.UI.Page
{
    
protected void Page_Load(object sender, EventArgs e)
    
{
        
if (!Page.IsPostBack)
        
{
            NewsBind();
        }

    }

    
private void NewsBind()//repeater分页并绑定
    {
        
string SqlStr = "select sNewsTitle,dAddTime from [News] order by dAddTime";        
        
string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionSqlServer"].ToString();
        SqlConnection conn 
= new SqlConnection(connectionString);
        conn.Open();
        SqlDataAdapter Adapter 
= new SqlDataAdapter(SqlStr, conn);
        DataSet ds 
= new DataSet();
        
try
        
{
            Adapter.Fill(ds, 
"testTable");
            PagedDataSource objPage 
= new PagedDataSource();
            objPage.DataSource
=ds.Tables["testTable"].DefaultView;
            objPage.AllowPaging
=true;
            objPage.PageSize
=3;
            
int CurPage;
            
if (Request.QueryString["Page"!= null)
            
{
                CurPage 
= Convert.ToInt32(Request.QueryString["page"]);
            }

            
else
            
{
                CurPage 
= 1;
            }

            objPage.CurrentPageIndex 
= CurPage - 1;
            LeaveMessage.DataSource
=objPage;//这里更改控件名称
            LeaveMessage.DataBind();//这里更改控件名称
            RecordCount.Text = objPage.DataSourceCount.ToString();
            PageCount.Text 
= objPage.PageCount.ToString();
            Pageindex.Text 
= CurPage.ToString();
            Literal1.Text 
= PageList(objPage.PageCount, CurPage);
            
//Literal1.Text = PageList(objPage.PageCount, Pageindex, L_Manage); //带参数的:LManage为参数


            FirstPage.NavigateUrl 
= Request.CurrentExecutionFilePath + "?page=1";
            PrevPage.NavigateUrl 
= Request.CurrentExecutionFilePath + "?page=" + (CurPage - 1);
            NextPage.NavigateUrl 
= Request.CurrentExecutionFilePath + "?page=" + (CurPage + 1);           
            LastPaeg.NavigateUrl 
= Request.CurrentExecutionFilePath + "?page=" + objPage.PageCount.ToString();
            
if (CurPage <= 1 && objPage.PageCount <= 1)
            
{
                FirstPage.NavigateUrl 
= "";
                PrevPage.NavigateUrl 
= "";
                NextPage.NavigateUrl 
= "";
                LastPaeg.NavigateUrl 
= "";
                
/*
                FirstPage.Visible = false;
                PrevPage.Visible = false;
                NextPage.Visible = false;
                LastPaeg.Visible = false;
                
*/

            }

            
if (CurPage <= 1 && objPage.PageCount > 1)
            
{
                FirstPage.NavigateUrl 
= "";
                PrevPage.NavigateUrl 
= "";
                
/*
                FirstPage.Visible = false;
                PrevPage.Visible = false;
                
*/



            }

            
if (CurPage >= objPage.PageCount)
            
{
                NextPage.NavigateUrl 
= "";
                LastPaeg.NavigateUrl 
= "";
                
/*
                NextPage.Visible = false;
                LastPaeg.Visible = false;
                
*/

            }

        }

        
catch(Exception error)
        
{
            Response.Write(error.ToString());
        }

        
finally
        
{
            conn.Close();
        }

    }

    
private string PageList(int Pagecount, int Pageindex)//private string Jump_List(int Pagecount , int Pageindex , long L_Manage)//带参数的传递
    {
        StringBuilder sb 
= new StringBuilder();
        
//下为带参数的传递
        
//sb.Append("<select id=\"Page_Jump\" name=\"Page_Jump\" onchange=\"window.location='" + Request.CurrentExecutionFilePath + "?page='+ this.options[this.selectedIndex].value + '&Org_ID=" + L_Manage + "';\">");
        
//不带参数的传递
        sb.Append("<select id=\"Page_Jump\" name=\"Page_Jump\" onchange=\"window.location='" + Request.CurrentExecutionFilePath + "?page='+ this.options[this.selectedIndex].value + '';\">");

        
for (int i = 1; i <= Pagecount; i++)
        
{
            
if (Pageindex == i)
                sb.Append(
"<option value='" + i + "' selected>" + i + "</option>");
            
else
                sb.Append(
"<option value='" + i + "'>" + i + "</option>");
        }

        sb.Append(
"</select>");
        
return sb.ToString();
    }


   
}