<%
dim conn
set Conn=Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq="&server.MapPath ("YourAccessMDB.mdb")
set rs=server.createobject("adodb.recordset")
SQl="select * from yourtablename "
rs.open sql,conn,1,1
do while not rs.eof
%>
<table >
<tr><td><%=rs("KeyName")%></td>
</tr></table>
<%
rs.movenext
loop
set rs=nothing
set conn=noting
%>
先对数据库进行存取,然后在把取出的数据在页面上显示出来,一下是这个的代码:
<%
dim conn
set Conn=Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq="&server.MapPath ("YourAccessMDB.mdb")
set rs=server.createobject("adodb.recordset")
SQl="select * from yourtablename "
rs.open sql,conn,1,1
do while not rs.eof
%>
<table >
<tr><td><%=rs("KeyName")%></td>
</tr></table>
<%
rs.movenext
loop
set rs=nothing
set conn=noting
%>
dim objconn
set objconn=server.createobject("adodb.connection")
objconn.connectionstring="driver={microsoft access driver (*.mdb)};"&"dbq="&server.mappath("rencai.mdb")
objconn.open
sqldel="delete * from job where id=id_num"
objconn.execute sqldel '总是报此行有错
'我用Win2000 + IIS调试
'ACCESS库同一目录下
objconn.close
set objconn=nothing
--------------------------------------------
<%
dim cnndb
set Cnndb=Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq="&server.MapPath ("数据库名.mdb")
set rstobj=server.createobject("adodb.recordset")
SQl="select * from 字段名 "
'这里就是你想要把表中的数据全部显示出来的SQL语句
rstobj.open sql,cnndb,1,1
do while not rstobj.eof '搜索记录
%>
'--------------
<table >
<tr>
'这里写你想要显示的的数据用表格写好后的每一条记录
'例:成绩 <% =rstobj("成绩")%>
</tr></table>
'--------------
<%
rstobj.movenext
loop
set rstobj=nothing
set cnndb=noting
%>
-----------------
<%
dim conn,connstr
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&server.mappath("test.mdb")
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
set rs=server.createobject("ADODB.recordset")
sql="select * from test where id= request.querystring("id")"
rs.open sql,conn,1,1
%>
<html>
<head>
<title>test</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<%
if not rs.eof then
%>
<table width="500" border="0" cellspacing="0" cellpadding="0">
<%
do
%>
<tr>
<td><%=rs("test1")%></td>
</tr>
<%
rs.movenext
loop until rs.eof
%>
</table>
<%
else
response.write "没有记录"
end if
%>
</body>
</html>