如何用ASP显示SQL表单?

[bbk_simon]

ASP菜鸟问题.
有一句SQL语句 select * from aaa
请问如何在用ASP在页面中显示出SQL结果的那张二维表.
谢谢

[zl13]

<%
sql = "select * from aaa"
Set rs = conn.execute(sql)
%>
<table>
<%
Do while not rs.Eof
response.write "<tr><td>"
response.write rs("aaa里的字段名")
response.write "</td></tr>"
rs.MoveNext
loop
%>
</table>

[xiaobird1]

这只是一个例子：

listsql = "select * from temp"
rs.open listsql, dbcon, 3, 1
for i = 0 to rs.Fields.Count - 1
Response.write rs.Fields(i).name & " "
next
Response.write "<br>"
for i = 0 to rs.RecordCount - 1
for j = 0 to rs.Fields.Count - 1
Response.write rs(j) & " "
next
Response.write "<br>"
rs.Movenext
next

如果代码有问题，请予更正。这只是一个例子。

[bbk_simon]

楼上的谢谢了先!
请问,如何用dictionary做呢?
假定select a,b,c from AAA