asp.net中一個linq分頁實現(xiàn)代碼

更新時間：2011年12月20日 11:57:50 作者：

asp.net中一個linq分頁實現(xiàn)代碼，需要的朋友可以參考下。

LInq分頁

 
testDataContext dc = new testDataContext(); 
public string GetPageNum(GridView GridViewName, int pagesize, IQueryable<test> sql) 
{ 
int page; 
if (HttpContext.Current.Request.QueryString["page"] != null) 
page = Convert.ToInt32(HttpContext.Current.Request.QueryString["page"]); 
else 
page = 1; 
//var sql = from o in dc.test select o; 
int total = sql.Count();//總數(shù)據(jù)量 
var sqls = sql.Skip((page - 1) * pagesize).Take(pagesize); 
GridViewName.DataSource = sqls; 
GridViewName.DataBind(); 
int allpage = 0; 
int next = 0; 
int pre = 0; 
int startcount = 0; 
int endcount = 0; 
string pagestr = ""; 
if (page < 1) { page = 1; } 
//計算總頁數(shù) 
if (pagesize != 0) 
{ 
allpage = (total / pagesize); 
allpage = ((total % pagesize) != 0 ? allpage + 1 : allpage); 
allpage = (allpage == 0 ? 1 : allpage); 
} 
next = page + 1; 
pre = page - 1; 
startcount = (page + 5) > allpage ? allpage - 9 : page - 4;//中間頁起始序號 
//中間頁終止序號 
endcount = page < 5 ? 10 : page + 5; 
if (startcount < 1) { startcount = 1; } //為了避免輸出的時候產(chǎn)生負數(shù)，設置如果小于1就從序號1開始 
if (allpage < endcount) { endcount = allpage; } //頁碼+5的可能性就會產(chǎn)生最終輸出序號大于總頁碼，那么就要將其控制在頁碼數(shù)之內(nèi) 
pagestr = "共" + allpage + "頁&nbsp;&nbsp;&nbsp;&nbsp"; 
pagestr += page > 1 ? "<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=1\">首頁</a>&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + pre + "\">上一頁</a>" : "首頁 上一頁"; 
//中間頁處理，這個增加時間復雜度，減小空間復雜度 
for (int i = startcount; i <= endcount; i++) 
{ 
pagestr += page == i ? "&nbsp;&nbsp;<font color=\"#ff0000\">" + i + "</font>" : "&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + i + "\">" + i + "</a>"; 
} 
pagestr += page != allpage ? "&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + next + "\">下一頁</a>&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + allpage + "\">末頁</a>" : " 下一頁 末頁"; 
return pagestr; 
} 

調(diào)用 label1.Test=GetPageNum(控件名稱，每頁顯示條數(shù)，linq查詢語句)
普通分頁

復制代碼代碼如下:

 
public static string GetPageNum(DataTable ds, DataList datalistname, int pagesize) 
{ 
PagedDataSource objPds = new PagedDataSource(); 
objPds.DataSource = ds.DefaultView; 
objPds.AllowPaging = true; 
int total = ds.Rows.Count; 
objPds.PageSize = pagesize; 
int page; 
if (HttpContext.Current.Request.QueryString["page"] != null) 
page = Convert.ToInt32(HttpContext.Current.Request.QueryString["page"]); 
else 
page = 1; 
objPds.CurrentPageIndex = page - 1; 
datalistname.DataSource = objPds; 
datalistname.DataBind(); 
int allpage = 0; 
int next = 0; 
int pre = 0; 
int startcount = 0; 
int endcount = 0; 
string pagestr = ""; 
if (page < 1) { page = 1; } 
//計算總頁數(shù) 
if (pagesize != 0) 
{ 
allpage = (total / pagesize); 
allpage = ((total % pagesize) != 0 ? allpage + 1 : allpage); 
allpage = (allpage == 0 ? 1 : allpage); 
} 
next = page + 1; 
pre = page - 1; 
startcount = (page + 5) > allpage ? allpage - 9 : page - 4;//中間頁起始序號 
//中間頁終止序號 
endcount = page < 5 ? 10 : page + 5; 
if (startcount < 1) { startcount = 1; } //為了避免輸出的時候產(chǎn)生負數(shù)，設置如果小于1就從序號1開始 
if (allpage < endcount) { endcount = allpage; } //頁碼+5的可能性就會產(chǎn)生最終輸出序號大于總頁碼，那么就要將其控制在頁碼數(shù)之內(nèi) 
pagestr = "共" + allpage + "頁&nbsp;&nbsp;&nbsp;&nbsp"; 
pagestr += page > 1 ? "<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=1\">首頁</a>&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + pre + "\">上一頁</a>" : "首頁 上一頁"; 
//中間頁處理，這個增加時間復雜度，減小空間復雜度 
for (int i = startcount; i <= endcount; i++) 
{ 
pagestr += page == i ? "&nbsp;&nbsp;<font color=\"#ff0000\">" + i + "</font>" : "&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + i + "\">" + i + "</a>"; 
} 
pagestr += page != allpage ? "&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + next + "\">下一頁</a>&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + allpage + "\">末頁</a>" : " 下一頁 末頁"; 
return pagestr; 
} 