DataList 分页

GridView功能很强大，但往往gridlist对于函数的实现（edit,delete,cancel...）的实现更为简洁，可他有个缺点就是，不能实现自动分页

 

搞了半个下午，终于搞定了，算是比较简洁的code吧，实现了GridList 分页

 

明天就要过19岁birthday了，今天记录一下成绩，鼓励一下！

 

1.第一步是在.aspx里插入一个DataList控件，并在编辑模板中分别用table实现ItemTemplate和EditItemTemplate列表，字段绑定（当然，也可以用SqlDataSource自动搞定）

 

<asp:DataList ID="DataList1" runat="server" CellPadding="4" DataKeyField="UserName" ForeColor="#333333" OnEditCommand="DataList1_EditCommand" OnCancelCommand="DataList1_CancelCommand" OnDeleteCommand="DataList1_DeleteCommand" OnUpdateCommand="DataList1_UpdateCommand" Width="431px"> <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <AlternatingItemStyle BackColor="White" /> <ItemStyle BackColor="#EFF3FB" /> <EditItemTemplate> <table class="style1"> <tr> <td> 用户名</td> <td> <asp:Label ID="Label1" runat="server" Text='<%# Eval("UserName") %>'></asp:Label> </td> </tr> <tr> <td> 真实姓名</td> <td> <asp:Label ID="Label3" runat="server" Text='<%# Eval("RealName") %>'></asp:Label> </td> </tr> <tr> <td> 性别</td> <td> <asp:Label ID="Label2" runat="server" Text='<%# Eval("Gender") %>'></asp:Label> </td> </tr> <tr> <td> 学校</td> <td> <asp:TextBox ID="TextBox4" runat="server" Text='<%# Eval("Colledge") %>'></asp:TextBox> </td> </tr> <tr> <td> 班级</td> <td> <asp:TextBox ID="TextBox5" runat="server" Text='<%# Eval("Classes") %>'></asp:TextBox> </td> </tr> <tr> <td> 学号</td> <td> <asp:TextBox ID="TextBox6" runat="server" Text='<%# Eval("StudentID") %>'></asp:TextBox> </td> </tr> <tr> <td> 权限</td> <td> <asp:DropDownList ID="DropDownList1" runat="server" SelectedValue='<%# Bind("Role") %>'> <asp:ListItem>Administrator</asp:ListItem> <asp:ListItem>NBU-acmer</asp:ListItem> <asp:ListItem>NormalStudent</asp:ListItem> </asp:DropDownList> </td> </tr> <tr> <td> 电话</td> <td> <asp:TextBox ID="TextBox8" runat="server" Text='<%# Eval("Phone") %>'></asp:TextBox> </td> </tr> <tr> <td> 电子邮箱</td> <td> <asp:TextBox ID="TextBox9" runat="server" Text='<%# Eval("Email") %>'></asp:TextBox> </td> </tr> </table> <br /> <asp:LinkButton ID="LinkButton3" runat="server" CommandName="update">更改</asp:LinkButton> <br /> <asp:LinkButton ID="LinkButton4" runat="server" CommandName="cancel">取消</asp:LinkButton> </EditItemTemplate> <SelectedItemStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" /> <HeaderTemplate> <asp:Label ID="Label4" runat="server" Text="用户信息"></asp:Label> </HeaderTemplate> <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <ItemTemplate> <table class="style1"> <tr> <td> 用户名</td> <td> <asp:Label ID="Label1" runat="server" Text='<%# Eval("UserName") %>'></asp:Label> </td> </tr> <tr> <td> 真实姓名</td> <td> <asp:Label ID="Label3" runat="server" Text='<%# Eval("RealName") %>'></asp:Label> </td> </tr> <tr> <td> 性别</td> <td> <asp:Label ID="Label2" runat="server" Text='<%# Eval("Gender") %>'></asp:Label> </td> </tr> <tr> <td> 学校</td> <td> <asp:Label ID="Label5" runat="server" Text='<%# Eval("Colledge") %>'></asp:Label> </td> </tr> <tr> <td> 班级</td> <td> <asp:Label ID="Label6" runat="server" Text='<%# Eval("Classes") %>'></asp:Label> </td> </tr> <tr> <td> 学号</td> <td> <asp:Label ID="Label7" runat="server" Text='<%# Eval("StudentID") %>'></asp:Label> </td> </tr> <tr> <td> 权限</td> <td> <asp:Label ID="Label8" runat="server" Text='<%# Eval("Role") %>'></asp:Label> </td> </tr> <tr> <td> 电话</td> <td> <asp:Label ID="Label9" runat="server" Text='<%# Eval("Phone") %>'></asp:Label> </td> </tr> <tr> <td> 电子邮箱</td> <td> <asp:Label ID="Label10" runat="server" Text='<%# Eval("Email") %>'></asp:Label> </td> </tr> </table> <br /> <asp:LinkButton ID="LinkButton1" runat="server" CommandName="edit" on >编辑</asp:LinkButton> <br /> <asp:LinkButton ID="LinkButton2" runat="server" CommandName="delete">删除</asp:LinkButton> <br /> </ItemTemplate> </asp:DataList>

 

2. 实现编辑、删除功能：

   ItemTemplate中     插入LinkButton（编辑、删除分别对应的CommandName为edit和delete）

   EditItemTemplate中      插入LinkButton（更改、取消分别对应的CommandName为update和cancel）

 

3. LinkButton 的实现：

  详见上面code，注意
        OnEditCommand="DataList1_EditCommand"
        OnCancelCommand="DataList1_CancelCommand"
        OnDeleteCommand="DataList1_DeleteCommand"
        OnUpdateCommand="DataList1_UpdateCommand"

  这几句的添加

 

4.  实现Edit,cancel,delete,update的代码：

//.cs中 protected void DataList1_EditCommand(object s, DataListCommandEventArgs e) { DataList1.EditItemIndex = e.Item.ItemIndex; DataList1.DataBind(); } protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e) { DataList1.EditItemIndex = -1; DataList1.DataBind(); } protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e) { //int Username = (int)DataList1.DataKeys[e.Item.ItemIndex]; //SqlDataSource1.DeleteParameters["UserName"].DefaultValue = Username.ToString(); //SqlDataSource1.Delete(); Label d = (Label)e.Item.FindControl("Label1"); string userName = d.Text.ToString(); new UserBLL().DeleteByID(userName); } protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e) { string userName = ((Label)e.Item.FindControl("Label1")).Text.ToString(); string school = ((TextBox)e.Item.FindControl("TextBox4")).Text.ToString(); string classes = ((TextBox)e.Item.FindControl("TextBox5")).Text.ToString(); string studentid = ((TextBox)e.Item.FindControl("TextBox6")).Text.ToString(); string role = ((DropDownList)e.Item.FindControl("DropDownList1")).Text.ToString(); string phone = ((TextBox)e.Item.FindControl("TextBox8")).Text.ToString(); string email = ((TextBox)e.Item.FindControl("TextBox9")).Text.ToString(); UserBLL userbll = new UserBLL(); Users user = userbll.FindByID(userName); user.UserName = userName; user.Colledge = school; user.Classes = classes; user.StudentID = studentid; user.Role = role; user.Phone = phone; user.Email = email; userbll.UpdateUserInfo(user); DataList1.EditItemIndex = -1; DataList1.DataBind(); }

 

5.  哈哈！重点来啦！！！实现DataList分页！

代码如下：

 

首先给.aspx中加上一个Label和两个HyperLink

当前页为<asp:Label ID="lblCurrentPage" runat="server" Text="当前页"></asp:Label> <asp:HyperLink ID="lnkPrev" runat="server">上一页</asp:HyperLink> <asp:HyperLink ID="lnkNext" runat="server">下一页</asp:HyperLink>

 

then, it comes to 后台 code

 //.cs public static bool flag = false; public void Page_Load(object src, EventArgs e) { if (!flag) { DataSet ds = new DataSet(); ds = new UserBLL().FindAll(); //对PagedDataSource 对象的相关属性赋值 PagedDataSource objPds = new PagedDataSource(); objPds.DataSource = ds.Tables[0].DefaultView; objPds.AllowPaging = true; objPds.PageSize = 3; int CurPage; //当前页面从Page查询参数获取 if (Request.QueryString["Page"] != null) CurPage = Convert.ToInt32(Request.QueryString["Page"]); else CurPage = 1; objPds.CurrentPageIndex = CurPage - 1; lblCurrentPage.Text = "Page: " + CurPage.ToString(); if (!objPds.IsFirstPage) lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1); if (!objPds.IsLastPage) lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1); //把PagedDataSource 对象赋给DataList控件 DataList1.DataSource = objPds; DataList1.DataBind(); } }

 

that's all!

 

Thanks for watching!