<%
on error resume next
set cn=server.createobject("adodb.connection")
cn.open "dsn=888"
sql="select * from tabel"
set fs=cn.execute(sql)
response.write "<table border=1>"
response.write "<tr>"
for i=0 to fs.fields.count-1 '依次输出字段名称
response.write "<td>" & fs(i).name & "</td>"
next
response.write "</tr>"
fs.movefirst
do while not fs.eof
response.write "<tr>"
for i=0 to fs.fields.count-1
if IsNull(fs(i).value) then
fs(i).value="无值"
..................