神马品牌网m4螺钉螺距:来段用ASP查询SQLSERVER数据库的代码
来源：百度文库 编辑：神马品牌网 时间：2024/04/30 02:06:12
查询结果要表格哦
<%
set conn=server.CreateObject("adodb.connection")
conn.provider = "microsoft.jet.oledb.4.0"
conn.open server.MapPath("log.mdb")
command = "SELECT * FROM student"
set rs = conn.execute(command,recordsAffected,adcmd)
response.write "<table border=3>"
response.write "<tr>"
for i=0 to rs.fields.count - 1
response.write "<td>"&ucase(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>"
set conn = nothing
%>
不用解释了吧，log.mdb 为你自己的数据库，student 为里面的表