Question

ASP连接数据表(ACCESS)

我在*.mdb数据库中的tb_info表里面建立了一个新的列.命名为info_admin
属于文本属性.怎么用ASP把这个列的内容显示出来?

Answer 1

<%
dim ConnString
set conn=server.CreateObject("adodb.connection")
ConnString="provider=microsoft.jet.oledb.4.0;data source=" & server.MapPath("*.mdb")
conn.open ConnString
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from tb_info",conn,1,3
if rs.bof and rs.eof then
response.write "<script>alert('无记录');history.back();</script>"
response.end
else
do while not rs.eof
%>
<div><%=rs("info_admin")%></div>
<%
rs.movenext
loop
rs.close
%>

Answer 2

use *.mdb
select info_admin from tb_info