Question

asp 用for循环生成10列的表格

数据库里的数据<%=rs("user")%>我想用10列的表格排列，行数不限。怎么用for循环写出来？
当然每列只允许放一个user

Answer 1

dim max = 100000
for i = 1 to max
response.write rs("user")
if i mod 10 = 0 then
response.write "<br>"
end if
rs.movenext
if rs.eof then
exit for
end if
next
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
dim i = 0
while not rs.eof
response.write rs("user")\
i = i + 1
if i mod 10 = 0 then
response.write "<br>"
end if
rs.movenext
wend

大致就是这样，没有经过测试，不知道能否正确执行，希望能帮到你。呵呵

Answer 2

<table border="1"><tr>
<%
set rs=Server.CreateObject("adodb.recordset")
rs.open "select * from 表名",conn,1,1
k=1
do while not rs.eof
%>
<td><%=rs("user")%></td>
<%
if k=10 then
Response.Write("</tr><tr>")
k=0
End if
rs.movenext
k=k+1
loop
rs.close
%>
</table>

Answer 3

<table>
<tr>
<%
i=0
do while not rs.eof
if (i mod 10) = 0 then
response.write "</tr><tr>"
i=0
end if
response.write "<td>"&rs("user")&"</td>"
i=i+1
rs.movenext
loop
%>
</tr>
</table>