神马品牌网汉中国际中学烹饪班:我的为全ASP程序那儿错了呢？
来源：百度文库 编辑：神马品牌网 时间：2024/04/27 16:55:15
我用的数据库是Access.我想把数据库中的所有记录一条一条地用表格的形式显示出来，以下是我写的ASP代码，大有错误，请那位ASP高手给我加上表格标记，再修改一下其它出错的地方。我将感谢不尽!
代码如下所示：
<!--include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
sql="select ID,name,number,sex,age,datatime from dbtable"
rs.open sql,conn,1,1
response.write("ID号","姓名","学号","性别","年龄","添加时间")
do while not rs.eof
response.write"ID,name,number,sex,age,datatime"
rs.movenext
loop
rs.close
conn.close
set rs=nothing
set conn=nothing
%>
代码如下所示：
<!--include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
sql="select ID,name,number,sex,age,datatime from dbtable"
rs.open sql,conn,1,1
response.write("ID号","姓名","学号","性别","年龄","添加时间")
do while not rs.eof
response.write"ID,name,number,sex,age,datatime"
rs.movenext
loop
rs.close
conn.close
set rs=nothing
set conn=nothing
%>
response.write"ID,name,number,sex,age,datatime"
这里是什么回事啊？是不是想显示数据库里的东西啊？应该是这样。
Response.Write rs("ID") & "," & rs("name") & "," & rs("number") & "," & rs("sex") & "," & rs("age") & "," & rs("datatime")