摘要: 1,直接通过sql语句分页 int Skip = (PageIndex - 1) * PageSize; int Take = PageSize; string strIsDesc = IsDesc ? "desc" : "asc"; StringBuilder sb = new StringBuilder(); sb.Append("with temp as (select top " + (Skip + Take)); sb.Append(" ROW_NUMBER() OVER(ORDER BY " + Ord 阅读全文
posted @ 2013-07-09 11:24 namehwh 阅读(185) 评论(0) 推荐(0) 编辑