用DW做asp页面文章列表

来源:百度知道 编辑:UC知道 时间:2024/06/30 14:07:00
用DW如果要显示数据库里的一个表 字段 的列表怎么做?
目前我只能显示一个标题 显示不了列表 最好告诉我在DW里怎么操作额

<%
SQL="select id,username,password,sex from zd_user"
Set Rs=conn.execute(SQL)
arrA = rs.GetRows()
Rs.close
set rs=nothing
CONN.close
set CONN=Nothing

cols = ubound(arrA,1)
rows = ubound(arrA,2)

response.write "记录集纵向显示"
response.write "<table border='1'>"
for i=0 to cols
response.write "<tr>"
for j=0 to rows
response.write "<td>"&arrA(i,j)&"</td>"
next
response.write "</tr>"
next
response.write "</table> "

response.write "<br>"
response.write "记录集横向显示"
response.write "<table border='1'>"
for i=0 to rows
response.write "<tr>"
for j=0 to cols
response.write "<td>"&arrA(j,i)&"</td>"
next
response.wri