• Linq to sql 分页


       在读取的数据集进行跳跃查询,关键方法Skip().Take(); 

       Skip跳过序列中指定的元素

       Take从序列的开头返回指定数量的连续元素

        var select = from n in entities.lib_reportinfo
                         join e in entities.lib_enterprise on n.Ep_Guid equals e.Guid into temp_ne
                         from tt in temp_ne.DefaultIfEmpty()
                         select new
                         {
                             guid = n.Guid,
                             epName = tt.Ep_Name,
                             epTrade = tt.Ep_Trade,
                             riName = n.Ri_ReportName,
                             riTime = n.Ri_PubTime,
                             riNd = n.Ri_ReportYear,
                             riCreateTime = n.CreateTime,
                             riPath = n.Ri_ReportPath
                         };
            pagecount.Text = select.ToList().Count.ToString();
            var query = select.OrderByDescending(r => r.riCreateTime).Skip(pagesize * (pageindex - 1)).Take(pagesize);       
            ListView1.DataSource = query;
            ListView1.DataBind();

  • 相关阅读:
    redis 内部数据结构 ziplist
    redis 内部数据结构 robj
    redis 内部数据结构 sds
    redis 内部数据结构 dict
    【工具篇 intellij idea】像eclipse的 Ctrl + T 那样查看类的继承结构
    【分享系列】+【提炼总结】一文掌控面试必备的TCP知识
    【搬砖系列】一图搞懂 取余 和 取模 运算
    IOS代理(初级)
    UITableView
    UITextField属性
  • 原文地址:https://www.cnblogs.com/ajun/p/2814511.html
Copyright © 2020-2023  润新知