Repeater控件绑定及分页

前言


学习牛腩的时候接触到Repeater控件,感觉很神奇。Repeater控件,DataList,Datagrid控件都能绑定数据库动态显示数据库等的内容。

Html代码

<head runat="server"><title>无标题页title>
head>
<body><form id="form1" runat="server"><div><h1>分页显示h1><p><asp:Label ID="Label1" runat="server" Text="当前页:">asp:Label><asp:Label ID="Label2" runat="server" Text="Label">asp:Label><asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="上一页" /><asp:Button ID="Button2" runat="server" Text="下一页" OnClick="Button2_Click" />p><asp:Panel ID="Panel1" runat="server" Height="224px" Width="503px"><asp:Repeater ID="Repeater1" runat="server"><ItemTemplate><tr><td><%# DataBinder.Eval(Container.DataItem,"LastName") %><%# DataBinder.Eval(Container.DataItem,"FirstName") %>td>tr>   ItemTemplate><AlternatingItemTemplate><tr><td><font color="blue"><%# DataBinder.Eval(Container.DataItem,"LastName") %><%# DataBinder.Eval(Container.DataItem,"FirstName") %>td>tr>   font>  AlternatingItemTemplate><HeaderTemplate><h3>模板页眉h3><table border="1"><tr><td>员工名字td>tr>HeaderTemplate><FooterTemplate><h3>模板页脚h3>table>FooterTemplate>asp:Repeater>asp:Panel>div>form>
body>

后台代码

public partial class repeaterControl : System.Web.UI.Page
{protected void Page_Load(object sender, EventArgs e){//第一次登录if (!this.IsPostBack){this.Label2.Text = "1";this.dataBindToRepeater();}}private void dataBindToRepeater(){int curPage = Convert.ToInt32(this.Label2.Text);SqlConnection con = DB.createCon();SqlDataAdapter sda = new SqlDataAdapter();sda.SelectCommand = new SqlCommand("select * from employees", con);DataSet ds = new DataSet();sda.Fill(ds, "emp");//分页用pageddatasourceSystem.Web.UI.WebControls.PagedDataSource ps = new PagedDataSource();ps.DataSource = ds.Tables["emp"].DefaultView;ps.AllowPaging = true;ps.PageSize = 3;ps.CurrentPageIndex = curPage - 1;this.Button1.Enabled = true;this.Button2.Enabled = true;if (curPage == 1){this.Button1.Enabled = false;}if (curPage == ps.PageCount){this.Button2.Enabled = false;}this.Repeater1.DataSource = ps;this.Repeater1.DataBind();}//上一页按钮单击protected void Button1_Click(object sender, EventArgs e){this.Label2.Text = Convert.ToString((Convert.ToInt32(this.Label2.Text)) - 1);this.dataBindToRepeater();}//下一页按钮单击protected void Button2_Click(object sender, EventArgs e){this.Label2.Text = Convert.ToString((Convert.ToInt32(this.Label2.Text)) + 1);this.dataBindToRepeater();}
}

结语


这几天主要学了一些asp.net中的控件:内置控件,复杂控件(广告控件和日历控件),验证控件和列表控件。不知道该如何总结,学的也是囫囵吞枣,还是应该找几个重点的例子敲一敲,实践实践。


本文来自互联网用户投稿,文章观点仅代表作者本人,不代表本站立场,不承担相关法律责任。如若转载,请注明出处。 如若内容造成侵权/违法违规/事实不符,请点击【内容举报】进行投诉反馈!

相关文章

立即
投稿

微信公众账号

微信扫一扫加关注

返回
顶部