像Asp一樣輕松分頁(yè)顯示數(shù)據(jù)(C#)

2019-11-18 19:47:31

字體：大中小

供稿：網(wǎng)友

代碼如下：

<%@ Page Language="C#" Debug="true" %>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.SqlClient"%>
<Script Language="C#" runat="server">
int Record_Per_Page;//定義每頁(yè)顯示記錄數(shù)
int nPageCount;//定義總頁(yè)數(shù)
int nRecCount;//定義總記錄數(shù)
int nPage;//定義當(dāng)前頁(yè)
void Page_Load(Object src,EventArgs e){
//取得當(dāng)前頁(yè)數(shù)值，并判斷
if(Request["pagesize"]==null)
Record_Per_Page=9;
else
Record_Per_Page=Convert.ToInt32(Request["pagesize"]);
//連接數(shù)據(jù)庫(kù)
SqlConnection conn;
conn =new SqlConnection(ConfigurationSettings.AppSettings["strconn"]);
conn.Open();

//執(zhí)行SQL語(yǔ)句
string ConnStr="select id,name,demo,pic from download where classid=23 or classid=24 order by time desc";
SqlDataAdapter odAdapt = new SqlDataAdapter(ConnStr,conn);
DataSet DS = new DataSet();
odAdapt.Fill(DS);
DataTable DT = DS.Tables[0];
//獲得總記錄數(shù)
nRecCount = DT.Rows.Count;

//判斷是否存在數(shù)據(jù)記錄
if(nRecCount > 0){
//確定數(shù)據(jù)記錄要顯示的頁(yè)面數(shù)
nPageCount=nRecCount/Record_Per_Page;
if(nRecCount % Record_Per_Page > 0)
nPageCount ++;
if(nPage < 1)
    nPage = 1;
if(nPage > nPageCount)
    nPage = nPageCount;
//將頁(yè)數(shù)顯示到屏幕上，并作鏈接
for(i=1;i<=nPageCount;i++){
   html=html+"<a href='mblist.aspx?page="+i+"&id="+classid+"&classname="+Request.Params["classname"]+"pagesize="+Record_Per_Page+"'>";
   if(i==nPage)
   html=html+"<b>"+i+"</b>";
   else
   html=html+i;
   html=html+"</a> ";
}
pagelist.InnerHtml=html;
html="";
//確認(rèn)當(dāng)前頁(yè)面的開(kāi)始記錄和終止記錄
int nStart = Record_Per_Page * (nPage - 1);
int nEnd = nStart + Record_Per_Page - 1;
if(nEnd > nRecCount - 1)
    nEnd = nRecCount - 1;
//在屏幕中輸出記錄
html="<table border='0' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#111111' width='95%' height='139' bgcolor='#ffffff'><tr>";
int j=0;
for(i=nStart;i<=nEnd;i++){
    html+="<td align=center height=180 ><table border='0' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#111111' width='145'><tr><td align=center><img src='http://bbs.wrclub.net/templates/"+DT.Rows[i]["demo"].ToString().Trim()+"/"+DT.Rows[i]["pic"].ToString().Trim()+"' height=143 width=140 border=0 alt='"+DT.Rows[i]["name"].ToString().Trim()+"'></td></tr><tr><td width='100%' background='images/mbbg.gif'><table border='0'cellpadding='0'cellspacing='0'width='100%'><tr><td width='50%'><a target='_blank'><img src='images/view.gif' border=0></a></td><td width='50%' align=right><a href='mbdown.aspx?id="+DT.Rows[i]["id"]+"' target=_blank><img src='images/down.gif' border=0></a></td></tr></table></td></tr></table></td>";
    j++;
    if(j%3==0)
    html+="</tr><tr>";
}
html+="</tr></table>";
mblist.InnerHtml=html;
html="";
}
conn.Close();
}
</script>