- 1PS提示：因為圖層已鎖定，無法編輯圖層的處理方法
- 2Adobe Illustrator CS5 序列號大全
- 3picacg蘋果版怎么找不到|picacg ios版是不是下架了介紹
- 4ACDsee注冊碼免費分享（含ACDsee18、ACDsee10等版本）
- 5蘋果iphone自動時間不準(zhǔn)確的多種校正方法
- 6眼萌app怎么色弱測試 眼萌app色弱測試圖文說明教程
- 7百度安全衛(wèi)士好用么_百度安全衛(wèi)士技巧說明
- 8PDF瀏覽器能看3D文件嗎？PDF瀏覽器看3D文件圖文詳細(xì)教程
- 9Potato(馬鈴薯聊天)怎么注冊不了|Potato不能注冊處理方法介紹
- 10Potato(土豆聊天)怎么換頭像|Potato app更改頭像方法介紹
- 11ipad版office如何激活? office365激活的圖文說明教程
- 12最新的Adobe Illustrator CS4序列號大全
聊天工具辦公軟件殺毒教程系統(tǒng)工具圖形圖像電腦學(xué)習(xí)應(yīng)用軟件網(wǎng)絡(luò)軟件蘋果應(yīng)用注冊碼網(wǎng)站教程技術(shù)開發(fā)安卓教程其它教程
您當(dāng)前所在位置：網(wǎng)視手游站 -> 網(wǎng)站教程 -> ASP應(yīng)用范例-分頁_代碼局部
ASP應(yīng)用范例-分頁_代碼局部
發(fā)表時間：2024-06-06 來源：明輝站整理相關(guān)軟件相關(guān)文章人氣：
[摘要]<% dim Conn,RS,sqlStr,PageSize,RowCount,TotalPages,PageNo,Position,PageBegin,PageEnd set Conn= Server.CreateObject("ADODB.Connection") s...
<%
dim Conn,RS,sqlStr,PageSize,RowCount,TotalPages,PageNo,Position,PageBegin,PageEnd
set Conn= Server.CreateObject("ADODB.Connection")
set RS = Server.CreateObject("ADODB.RecordSet")
Conn.open "provider=sqloledb;data source=127.0.0.1;user id=sa;password=;initial catalog=zjydata"
sqlStr="select * from Items order by iID"
RS.open sqlStr,Conn,1,1
PageSize=10
If RS.RecordCount=0 then
%>
<TABLE WIDTH=100% BORDER=0 CELLPADDING=1 CELLSPACING=1 style='font-size:9pt'>
<TR bgcolor=#003366 height=20px>
<TD align=center><font color=#FFFFFF>商品代碼</font></TD>
<TD align=center><font color=#FFFFFF>商品名稱</font></TD>
<TD align=center><font color=#FFFFFF>型號規(guī)格</font></TD>
<TD align=center><font color=#FFFFFF>計量單位</font></TD>
<TD align=center><font color=#FFFFFF>參考進(jìn)價</font></TD>
<TD align=center><font color=#FFFFFF>參考售價</font></TD>
<TD align=center><font color=#FFFFFF>備注</font>
</TR>
<TR height=20px>
<TD align=center>沒有任何商品信息!</TD>
<TR>
</TABLE>
<%
else
RS.PageSize = Cint(PageSize)
TotalPages=RS.PageCount
PageNo=Request.QueryString("PageNo")
if PageNo="" or PageNo<1 Then
PageNo = 1
end if
RS.AbsolutePage = PageNo
Position=RS.PageSize*PageNo
PageBegin=Position-RS.PageSize+1
if Position <RS.RecordCount then
PageEnd=Position
else
PageEnd= RS.RecordCount
end if
%>
<TABLE WIDTH=100% BORDER=0 CELLPADDING=1 CELLSPACING=1 style='font-size:9pt'>
<TR>
<TD width=20%>
<%
Response.Write "頁："& PageNo &" / "& TotalPages &" 記錄："& PageBegin & " - " & PageEnd & " / " &RS.RecordCount
%>
</TD>
<TD align=right>
<%
if PageNo > 1 Then
response.write "<a href=list.asp?PageNo=1>首頁</a> <a href=list.asp?PageNo=" & (PageNo-1) & ">上頁</a> "
end if
if TotalPages > 1 and cint(PageNo) <> cint(TotalPages) then
response.write "<a href=list.asp?PageNo=" & (PageNo+1) & ">下頁</a> <a href=list.asp?PageNo=" & TotalPages & ">末頁</a> "
end if
%>
</TD>
</TR>
<TR bgcolor=#003366 height=20px>
<TD align=center width=20%><font color=#FFFFFF>商品代碼</font></TD>
<TD align=center width=30%><font color=#FFFFFF>商品名稱</font></TD>
<TD align=center width=8%><font color=#FFFFFF>型號規(guī)格</font></TD>
<TD align=center width=8%><font color=#FFFFFF>計量單位</font></TD>
<TD align=center width=8%><font color=#FFFFFF>參考進(jìn)價</font></TD>
<TD align=center width=8%><font color=#FFFFFF>參考售價</font></TD>
<TD align=center width=18%><font color=#FFFFFF>備注</font></TR>
<%
RowCount = RS.PageSize
dim color1,color2
color1="#dddddd"
color2="#eeeeee"
Do While Not RS.EOF and RowCount > 0
Response.Write "<TR height=20px bgcolor="
%>
<%
if RowCount mod 2=0 then:response.write color1 else:response.write color2
%>
<%
Response.Write ">"
%>
<TD><span><a href=manage.asp?id=<%=rs(0)%>><% =RS("vCode")%></a></span></td>
<TD><span><% =RS("vName")%></span></td>
<TD><span><% =RS("vSpec")%></span></TD>
<TD><span><% =RS("vUnit")%></span></td>
<TD><span><% =RS("fInPrice")%></span></td>
<TD><span><% =RS("fOutPrice")%></span></TD>
<TD><span><% =RS("vDescription")%></span></td>
</TR>
<%
RowCount = RowCount - 1
RS.MoveNext
Loop
Conn.Close
set RS = nothing
set Conn = nothing
%>
<TR bgcolor=#003366 height=20px>
<TD align=center width=20%><font color=#FFFFFF>商品代碼</font></TD>
<TD align=center width=30%><font color=#FFFFFF>商品名稱</font></TD>
<TD align=center width=8%><font color=#FFFFFF>型號規(guī)格</font></TD>
<TD align=center width=8%><font color=#FFFFFF>計量單位</font></TD>
<TD align=center width=8%><font color=#FFFFFF>參考進(jìn)價</font></TD>
<TD align=center width=8%><font color=#FFFFFF>參考售價</font></TD>
<TD align=center width=18%><font color=#FFFFFF>備注</font>
</TR>
<TR>
<TD>
<%
For i=1 to TotalPages
if CInt(PageNo) = CInt(i) then
response.write "["&i&"]"
else
response.write " <a href=list.asp?PageNo="&i&">"&i&"</a> "
end if
Next
%>
</TD>
</TR>
</TABLE>
<%
End if
%>
標(biāo)簽：ASP應(yīng)用范例-分頁_代碼局部
推薦資訊 總?cè)藲獍?/span>
相關(guān)文章
