ASP.NET的Web网页如何进行分页操作（Demo举例）

逃离我推掉我的手 2023-03-13 11:44 3阅读 0赞

大概说一下思路，[可以利用sql的 Offset/Fetch Next分页，点击这里][sql_ Offset_Fetch Next]  
这里的Demo利用LINQ的写好的方法

//这里是某个表的列表 skip是跳过前面的多少条数据 take这是跳过前面的数据后显示多少条数据
    db.Albums.ToList().Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList();

我们是四个按钮一个首页，上一页，下一页，尾页，点击跳转  
有不明白的，或者小编描述错误的模糊的欢迎评论私信

这个页面的前台页面

<%@ Page Title="" Language="C#" MasterPageFile="~/Admin/AdminSite.Master" AutoEventWireup="true" CodeBehind="MusicManager.aspx.cs" Inherits="WebApplication1.Admin.MusicManager1" %>
    
    <asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
    
        <link href="../Assets/css/input.css" rel="stylesheet" />
    </asp:Content>
    <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    
        <div class="pure-form">
            <fieldset>
                <%--genres表--%>
                <legend>后台管理<i class="fa fa-angle-double-right"></i>音乐管理
                    <asp:Button ID="Button1" runat="server" CssClass="button-default pure-button-primary tools-button" Text="添加音乐" OnClick="Button1_Click" />
                </legend>
            </fieldset>
        </div>
        <table class="pure-table">
            <thead>
                <tr>
                    <th>#</th>
                    <th>音乐名称</th>
                    <th>歌手名称</th>
                    <th>标题</th>
                    <th>单价</th>
                    <th>图片</th>
                    <th>编辑</th>
                </tr>
            </thead>
            <tbody>
                <asp:Repeater ID="Repeater1" runat="server" OnItemCommand="Repeater1_ItemCommand">
                    <ItemTemplate>
                        <tr>
                            <td><%# Eval("AlbumId") %></td>
                            <td><%# Eval("Genres.Name") %></td>
                            <td><%# Eval("Artists.Name") %></td>
                            <td><%# Eval("Title") %></td>
                            <td><%# Eval("Price") %></td>
                            <td><%#  Eval("AlbumArtUrl") %><asp:Image ID="Image1" ImageUrl='<%# "~"+Eval("AlbumArtUrl") %>' runat="server" Width="40px" Height="40px" /></td>
                            <td>
                                <asp:LinkButton ID="LinkButton1" CssClass="button-default pure-button-primary" runat="server" CommandArgument='<%#Eval("AlbumId") %>' CommandName="Edit">编辑</asp:LinkButton>
                                <asp:LinkButton ID="LinkButton2" CssClass="button-default button-error" runat="server" CommandArgument='<%#Eval("AlbumId") %>' CommandName="Delete">删除</asp:LinkButton></td>
    
                        </tr>
                    </ItemTemplate>
                </asp:Repeater>
                <tr>
                    <td colspan="6">
                        <asp:Label ID="Label1" runat="server"></asp:Label>
                        <asp:Button ID="btnFirst" runat="server" Text="首页" OnClick="btnFirst_Click" />
                        <asp:Button ID="btnPrev" runat="server" Text="上页" OnClick="btnPrev_Click" />
                        <asp:Button ID="btnNext" runat="server" Text="下页" OnClick="btnNext_Click" />
                        <asp:Button ID="btnLast" runat="server" Text="尾页" OnClick="btnLast_Click" />
    
    
                    </td>
                </tr>
            </tbody>
    
    
    
        </table>
    </asp:Content>

这个页面的后台页面

using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    using WebApplication1.BLL;
    using WebApplication1.DAL;
    
    namespace WebApplication1.Admin
    { 
        public partial class MusicManager1 : System.Web.UI.Page
        { 
            protected void Page_Load(object sender, EventArgs e)
            { 
                if (!IsPostBack)
                    LoadData();
            }
    
            protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
            { 
                string str = e.CommandName.ToString();
                //这里获取id，我的id是刚才我赋值的时候CommandArgument是赋值的id
                int id = Convert.ToInt32(e.CommandArgument.ToString());
                //using (OLMSDBEntities oLMSDB = new OLMSDBEntities())
                //{ 
    
    
                // var gener = oLMSDB.Genres.FirstOrDefault(t => t.GenreId == id);
                if (str == "Delete")
                { 
    
                    //后面是对数据库的操作，可以忽略
                    // oLMSDB.Genres.Remove(gener);
                    bool flag_deleteMussicType = BLL.MusicManager.deleteMusicManager(id);
    
    
                    if (flag_deleteMussicType)
                    { 
                        string strUrl = "<script>alert('删除成功');window.location.href='MusicManager.aspx'</script>";
                        Response.Write(strUrl);
                    }
                    else
                    { 
                        string strUrl = "<script>alert('删除失败');</script>";
                        Response.Write(strUrl);
                    }
                }
                else if (str == "Edit")
                { 
                    Response.Redirect($"Edit_MusicManager.aspx?id={id}");
    
                }
            }
    
            protected void Button1_Click(object sender, EventArgs e)
            { 
                Response.Redirect("Add_MusicManager.aspx");
            }
          
    
    
    		//分页的具体代码
    
    
    
            //页码
            public int pageNumber
            { 
                //取值的话，如果里面没有就说明第一次进入，然后给它赋值，下面在取值
                get
                { 
                    if (ViewState["page"] == null)
                    { 
                        return 1;
                    }
                    else
                    { 
                        return Convert.ToInt32(ViewState["page"]);
                    }
                }
                set
                { 
                    ViewState["page"] = value;
                }
            }
            //每页的记录数
            public int pageSize
            { 
                get
                { 
                    return 5;
                }
            }
            //总页数
            public int pageCount
            { 
                get
                { 
                    if (ViewState["count"] == null)
                    { 
                        return 1;
                    }
                    else
                    { 
                        return Convert.ToInt32(ViewState["count"]);
                    }
                }
                set
                { 
                    ViewState["count"] = value;
                }
            }
    
    
            public void LoadData()
            { 
                using (OLMSDBEntities oLMSDB = new OLMSDBEntities())
                {                           //这里是某个表的列表 skip是跳过前面的多少条数据 take这是跳过前面的数据后显示多少条数据
                                           // //这里是我需要显示第三页的数据，我们要跳过二页的数据，所以是（3-1）*一页的数据量
                    Repeater1.DataSource = oLMSDB.Albums.ToList().Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList();
                    Repeater1.DataBind();
                    pageCount = oLMSDB.Albums.ToList().Count;
                    Label1.Text = $"每页{pageSize}条，共{pageCount}条 ";
                    //我们最后剩下一行数据也要在加一页，如果有余数就要加一页
                    pageCount = pageCount % pageSize == 0 ? pageCount / pageSize : pageCount / pageSize + 1;
                }
                Label1.Text += "当前页数为" + pageNumber + "/" + pageCount;
            }
    
            //首页
            protected void btnFirst_Click(object sender, EventArgs e)
            { 
                pageNumber = 1;
                LoadData();
            }
    
            //上一页
            protected void btnPrev_Click(object sender, EventArgs e)
            { 
                //防止到0页，如果到0页的话，我们就是到1页
                pageNumber = pageNumber - 1 < 1 ? pageNumber = 1 : pageNumber - 1;
    
                LoadData();
            }
    
            //下一页
            protected void btnNext_Click(object sender, EventArgs e)
            { 
                //防止超出所有的页面总数，超出的话，就赋值页面总数
                pageNumber = pageNumber + 1 > pageCount ? pageNumber = pageCount : pageNumber + 1;
                LoadData();
            }
    
            //尾页
            protected void btnLast_Click(object sender, EventArgs e)
            { 
                pageNumber = pageCount;
                LoadData();
            }
        }
    }

效果图

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ExNDM5Nzc1NTIw_size_16_color_FFFFFF_t_70]

[sql_ Offset_Fetch Next]: https://blog.csdn.net/a1439775520/article/details/104464608
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ExNDM5Nzc1NTIw_size_16_color_FFFFFF_t_70]: /images/20230312/f8a9ef34d7d143348f4fff34b4c10bbc.png