Repeater的分页代码

最新推荐文章于 2024-07-07 23:10:31 发布

emoheshang

最新推荐文章于 2024-07-07 23:10:31 发布

阅读量452

点赞数

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

本文链接：https://blog.csdn.net/emoheshang/article/details/4154355

版权

ASP.NET 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

Default.aspx.cs里的代码
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class _Default : System.Web.UI.Page
{
Class1 cs = new Class1();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
fill();
}

}
private void fill()
{
int cup = Convert.ToInt32(pagelbl.Text);
PagedDataSource ps = new PagedDataSource();
DataSet ds = new DataSet();
ds = cs.GetDs();
ps.DataSource=ds.Tables[0].DefaultView;
ps.AllowPaging = true;
ps.PageSize = 6;
ps.CurrentPageIndex = cup - 1;
if (!IsPostBack)
{
for (int i = 0; i < ps.PageCount; i++)
{
pageddl.Items.Add(i.ToString());
}
}
pageup.Enabled = true;
pageDown.Enabled = true;
if (ps.IsFirstPage)
{
pageup.Enabled = false;
}
if (ps.IsLastPage)
{
pageDown.Enabled = false;
}
pageddl.SelectedItem.Text = cup.ToString();
Repeater1.DataSource = ps;
Repeater1.DataBind();
}
protected void pageddl_SelectedIndexChanged(object sender, EventArgs e)
{
pagelbl.Text = pageddl.SelectedItem.Text.ToString();
fill();
}
protected void pageup_Click(object sender, EventArgs e)
{
pagelbl.Text = Convert.ToString(Convert.ToInt32(pagelbl.Text) - 1);
fill();
}
protected void pageDown_Click(object sender, EventArgs e)
{
pagelbl.Text = Convert.ToString(Convert.ToInt32(pagelbl.Text)+1);
fill();

}
}
源代码
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

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

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>无标题页 </title>
</head>
<body>
<form id="form1" runat="server">
<div>

<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<%#DataBinder.Eval(Container.DataItem,"job_id") %>
</ItemTemplate>
</asp:Repeater>

<asp:Label ID="pagelbl" runat="server" Text="1" Visible="False"> </asp:Label>
<asp:LinkButton ID="pageup" runat="server" οnclick="pageup_Click">上一页 </asp:LinkButton>
<asp:DropDownList ID="pageddl" runat="server"
onselectedindexchanged="pageddl_SelectedIndexChanged">
</asp:DropDownList>
<asp:LinkButton ID="pageDown" runat="server" οnclick="pageDown_Click">下一页 </asp:LinkButton>

</div>
</form>
</body>
</html>
Class1.cs里的代码
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

/// <summary>
///Class1 的摘要说明
/// </summary>
public class Class1
{
string connstr = "server=.;database=pubs;uid=sa;pwd=";
public DataSet GetDs()
{
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from jobs",conn);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
return ds;

}
}

emoheshang

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Repeater的分页代码

Default.aspx.cs里的代码 using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls;
复制链接

扫一扫