怎么获得数据库中某个表的所有字段列表? 假设一个Access数据库为data.mdb,齐中一个表名为table1。tabel1中有数个字段列表。用什么方法获得这些字段列表??如果用SQL查询语句也可以,又怎么写呢? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Option ExplicitDim RS As New ADODB.RecordsetDim Conn As New ADODB.ConnectionPrivate Sub Form_Load() Dim strConn As String Dim i As Integer strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=Localhost" Conn.CursorLocation = adUseClient Conn.Open strConn If RS.State <> adStateClosed Then RS.Close RS.Open "Select * from Jobs", Conn, adOpenStatic, adLockOptimistic For i = 0 To RS.Fields.Count - 1 Debug.Print RS.Fields(i).name Next i End Sub RS.Open "Select * from Jobs where 1=2", Conn, adOpenStatic, adLockOptimistic 如果虽SQL数据库,select a.name from syscolumns a where a.id=object_id('你的表名') 用setup factory打包的时候excle.exe 和stdole2.tlb 是什么啊? 需要一起打包么? 求VB常用算法大全 VB其实不该被用成这样 帮我看看,我这段代码如何错了! 一个关于Rnd的基本问题 如何在VB的类模块中加一个与VB内部函数同名的函数? VB生成的EXE文件不在WINDOWS环境下能运行吗? 老板毕竟是老板,打工的始终是打工的!!!愤怒中,散分去去晦气。 请 分儿 进来看看 commondialog控件的flags设置问题 sql与excel之间的导入问题。 [在线等待]大家看我写的删除语句,怎么刷新啊
Dim Conn As New ADODB.Connection
Private Sub Form_Load()
Dim strConn As String
Dim i As Integer
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=Localhost"
Conn.CursorLocation = adUseClient
Conn.Open strConn
If RS.State <> adStateClosed Then RS.Close
RS.Open "Select * from Jobs", Conn, adOpenStatic, adLockOptimistic
For i = 0 To RS.Fields.Count - 1
Debug.Print RS.Fields(i).name
Next i
End Sub
RS.Open "Select * from Jobs where 1=2", Conn, adOpenStatic, adLockOptimistic
select a.name from syscolumns a where a.id=object_id('你的表名')