asp获取数据库中表名和字段名的代码

set rs=server.CreateObject(“adodb.recordset”)
db=”db1.mdb”
set cOnn=server.CreateObject(“adodb.connection”)
cOnnstr=”Provider=Microsoft.Jet.OLEDB.4.0;Data Source=” & Server.MapPath(db)
conn.open connstr

Set rs=Conn.OpenSchema(20)
Do Until rs.EOF

If rs(3)=”TABLE” Then
response.write “表名:”&rs(2)&”
”
Set rs1=server.CreateObject(“adodb.recordset”)
sql=”select * from “&rs(2)
Set rs1=conn.execute(sql)
response.write “字段名:”
For i=0 To rs1.fields.count-1
response.write rs1.fields(i).name&” ”
Next
response.write “
”

Do While Not rs1.eof
response.write ” ”
For i=0 To rs1.fields.count-1
t=rs1.fields(i).name
response.write rs1(t)&” ”
Next
response.write ” ”
rs1.movenext
Loop
response.writ来源gao([email protected]@#码网e ” ”
End If

rs.MoveNext
Loop

Set rs=Nothing
Set cOnn=nothing
% >