<tr>
<td width="700" valign="top" align="left">
<!--加载数据库产品列表包含分页代码开始 -->
<table width="700" cellpadding="0" cellspacing="0" border="0" align="center">
<%
sql="SELECT * from Products WHERE HasDel = 0"
set rs = server.CreateObject ("adodb.recordset")
rs.Open sql,conn,1,1
rs.PageSize = 9
pageno = Request("pageno")
if pageno = "" then
pageno = 1
end if
if not rs.EOF then
rs.AbsolutePage = pageno
end if
num = (pageno - 1) * rs.PageSize
for i = 1 to rs.PageSize
if rs.EOF then
for t = i to rs.PageSize
%>
<tr class=RigaVistaTratteggiata >
<td colspan="7" height="5" valign=bottom align=left></td>
</tr>
<tr onMouseOut="this.style.backgroundColor='';" onMouseOver="this.style.backgroundColor='#DBE4EB';">
<%
next
exit for