举个例子,你慢慢掌握吧.
set conn=server.createobject("adodb.connection")
conn.open "Provider = Microsoft.Jet.OLEDB.4.0;Data Source =" & server.mappath("test.mdb")
set rs=conn.execute("select name1 from table1")
while not rs.eof
Response.write(rs("name1")&"<br>")
rs.movenext
loop
set conn=server.createobject("adodb.connection")
conn.open "Provider = Microsoft.Jet.OLEDB.4.0;Data Source =" & server.mappath("test.mdb")
set rs=conn.execute("select name1 from table1")
while not rs.eof
Response.write(rs("name1")&"<br>")
rs.movenext
loop
set conn=server.createobject("adodb.connection")
conn.open "Provider = Microsoft.Jet.OLEDB.4.0;Data Source =" & server.mappath("test.mdb")
set rs=conn.execute("select name1 from table1")
do while not rs.eof
Response.write(rs("name1")&"<br>")
rs.movenext
loop用来连接与网页相同目录下的test.mdb数据库,同时显示该数据库中的table1表中的name1字段的所有记录