首页 > 代码库 > Linq分页

Linq分页

        /// <summary>        /// Linq分页        /// </summary>        int pagesize = 2;//每页条数        int recordcount = 0;//总条数        int pageindex = 1;//当前第几页        public static string con = ConfigurationManager.ConnectionStrings["MySQLDBConnectionString"].ConnectionString;        GuestBookDataContext ctx = new GuestBookDataContext(con);        public StringBuilder sb = new StringBuilder();        public void GetPage()        {            if (!String.IsNullOrEmpty(Request.QueryString["page"]))            {                pageindex = Convert.ToInt32(Request.QueryString["page"]);            }            recordcount = ctx.tbGuestBook.Count();            int pagecount = (int)Math.Ceiling((decimal)recordcount/pagesize);//总页数            sb.Append("共<font style=‘color:#FF0000‘>"+pageindex+"</font>/"+pagecount+"");            for (int i = 1; i <= pagecount; i++)            {                sb.AppendFormat(@"<a href=http://www.mamicode.com/‘?page={0}‘>{0}",i);            }            var data = http://www.mamicode.com/(from gb in ctx.tbGuestBook orderby gb.PostTime descending select gb).Skip((pageindex-1)*pagesize).Take(pagesize);            rpt_Message.DataSource = data;            rpt_Message.DataBind();        }

aspx调用页码代码: