爱站程序员基地大概说一下思路，可以利用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是赋值的idint 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();}}}
效果图
