如何用Asp取得數(shù)據(jù)庫(kù)中所有表名和字段名_ASP教程

教程Tag：暫無(wú)Tag,歡迎添加,賺取U幣!

推薦：Asp讀取文本文件并顯示
html head http-equiv=Content-Type content=text/html; charset=gb2312 title/title /head body % LANGUAGE = VBScript % % Const ForReading = 1, ForWriting = 2, ForAppending = 8 Const TristateUseDefault = -2, TristateTrue = -1, TristateFalse

< %
set rs=server.CreateObject("adodb.recordset")
db="db.mdb"
'只要直接更改數(shù)據(jù)庫(kù)名稱就能夠看到效果了。
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)&"<br />"
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 "<br />"

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.write " "
End If

rs.MoveNext
Loop

Set rs=Nothing
Set conn=nothing
% >

分享：asp怎樣利用InstrRev()獲取文件名
InstrRev函數(shù)，從字符串的最后一個(gè)搜索起，前面字符串。 % Dim strTXT,pos strTXT=www.webjx.com pos=instrRev(strTXT,.) Response.Write pos % 我們搜索的起始是倒序，從com前的一個(gè)點(diǎn)。起始的字符的長(zhǎng)度，含此點(diǎn)，共十個(gè)字符，返回的結(jié)果將是9。通過(guò)