Repeater分页

最新推荐文章于 2023-12-13 09:47:15 发布

bing1051

最新推荐文章于 2023-12-13 09:47:15 发布

阅读量521

点赞数

分类专栏： ASP.NET 文章标签： hyperlink server asp dataset object user

ASP.NET 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

页面源码：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="repeater.aspx.cs" Inherits="repeater" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

        </tr>
        </table>
        </FooterTemplate>
        </asp:Repeater>

    </div>
    </form>
</body>
</html>
------------------------------------------------------------------------------------------------------------------------

.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;

public partial class repeater : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Repeater1.DataSource = pds();
            Repeater1.DataBind();
        }
    }

    private PagedDataSource pds()
    {
        string connstring = ConfigurationManager.ConnectionStrings["connsky"].ConnectionString;
        SqlConnection con = new SqlConnection(connstring);

            DataSet ds = new DataSet();
            SqlDataAdapter sda = new SqlDataAdapter("select * from [user]", con);
            sda.Fill(ds,"user1");
        SqlDataAdapter sda2 = new SqlDataAdapter("select * from record",con);
        sda2.Fill(ds,"score1");

ds.Relations.Add("myrela",ds.Tables["user1"].Columns["id"],ds.Tables["score1"].Columns["u_id"]);

        PagedDataSource pds = new PagedDataSource();
        pds.DataSource = ds.Tables["user1"].DefaultView;
        pds.AllowPaging = true;
        pds.PageSize = 5;
        pds.CurrentPageIndex = Convert.ToInt32(Request.QueryString["page"]);
        return pds;
    }

    protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Footer)
        {//如果是脚模板
            //取到分页控件的对象
            DropDownList ddlp = (DropDownList)e.Item.FindControl("ddlp");

            HyperLink lpfirst = (HyperLink)e.Item.FindControl("hlfir");
            HyperLink lpprev = (HyperLink)e.Item.FindControl("hlp");
            HyperLink lpnext = (HyperLink)e.Item.FindControl("hln");
            HyperLink lplast = (HyperLink)e.Item.FindControl("hlla");

//将下拉框的当前索引赋值给分页对象的当前页
pds().CurrentPageIndex = ddlp.SelectedIndex;

int n = Convert.ToInt32(pds().PageCount);//n为分页数
int i = Convert.ToInt32(pds().CurrentPageIndex);//i为当前页

            Label lblpc = (Label)e.Item.FindControl("lblpc");
            lblpc.Text = n.ToString();
            Label lblp = (Label)e.Item.FindControl("lblp");
            lblp.Text = Convert.ToString(pds().CurrentPageIndex+1);

            if (!IsPostBack)
            {
                for (int j = 0; j < n; j++)
                {
                    ddlp.Items.Add(Convert.ToString(j+1)); //填充下拉框
                }
            }
            if (i <= 0)
            {//如果当前页未首页
                lpfirst.Enabled = false;
                lpprev.Enabled = false;
                lplast.Enabled = true;
                lpnext.Enabled = true;
            }
            else
            {
                lpprev.NavigateUrl = "?page=" + (i - 1);
            }

            if (i >= n - 1)
            {//如果当前页为末页
                lpfirst.Enabled = true;
                lplast.Enabled = false;
                lpnext.Enabled = false;
                lpprev.Enabled = true;
            }
            else
            {
                lpnext.NavigateUrl = "?page="+(i+1);
            }

lpfirst.NavigateUrl = "?page=0";//向本页传递参数page

lplast.NavigateUrl="?page="+(n-1);//导航到最后一页

            ddlp.SelectedIndex = Convert.ToInt32(pds().CurrentPageIndex);//导航后把当前页的页码赋值给下拉框
        }
    }
    protected void ddlp_SelectedIndexChanged(object sender, EventArgs e)
    {//脚模板中的下拉列表框更改时激发
        string pg = Convert.ToString((Convert.ToInt32(((DropDownList)sender).SelectedValue)-1));//获取列表框当前选中项

Response.Redirect("repeater.aspx?page=" + pg);//页面转向
}

}