源代码
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.
<html xmlns="http://www.
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>使用execute方法查询数据</title>
</head>
<body>
<%
set conn=server.CreateObject("adodb.connection")
dsntemp="driver={microsoft access driver (*.mdb)};"
dsntemp=dsntemp & "dbq=" & server.MapPath("hello.mdb")
conn.open dsntemp
set rs=conn.execute("select * from hTable",howmany,adcmdtext)
response.Write "<table border=1>"
response.Write "<tr>"
for i=0 to rs.fields.count-1
response.Write "<td>" & rs(i).name & "</td>"
next
response.Write "</tr>"
while not rs.eof
response.Write "<tr>"
for i=0 to rs.fields.count-1
response.Write "<td>" & rs(i).value & "</td>"
next
rs.movenext
response.Write "</tr>"
wend
response.Write "</table>"
response.Write "共有" & howmany & "条记录"
rs.close
conn.close
%>
</body>
</html>
显示结果
编号 hColumn
11 goodbye
14 new Data
15 new Data
共有-1条记录
不知道哪里错了，结果显示共有-1条记录。哪位能帮忙改改，小弟先谢了