ASP.net简单分页

//控制器

//实例化实体
TestEntities1 test =new TestEntities1();

//定义页数
int pageIndex;

//查看接收的页数 如果不能转 则重置为1
  if (!int.TryParse(Request["pageIndex"], out pageIndex))
  {
     pageIndex = 1;
  }

//定义每页条数
int pageSize=5;

//查看总条数据
int recordCount =test.Users.count()

//看可以分多少页
int pageCount =convert.ToInt32((double)recordCount/pageSize);

//处理不合法数据 
pageIndex=pageIndex<1?1:pageIndex;
pageIndex=PageIndex>pageCount ? pageCount : pageIndex;

//查询出数据 
var usersList =test.Users.Where<Users>(u=>true).OrderBy<Users,int>(u=>Id).Skip<Users>((pageIndex-1)*pageSize).Take<Users>(pageSize);

ViewData["userList"] = usersList;

//视图
//view
IQueryable<MVC1.Models.Users> ul = (IQueryable<MVC1.Models.Users>)ViewData["userList"];
    foreach (var u in ul)
    {
        <tr>
            <td>@u.UserCode</td>
            <td>@u.UserName</td>
            <td>@u.Pwd</td>
        </tr>
        }
    }

 

posted @ 2018-04-02 16:02  伪装大牛  阅读(312)  评论(0编辑  收藏  举报