如何列举数据库中所有的表名?(在线等待!) http://www.csdn.net/expert/topic/607/607737.xml?temp=.1163446请参考此贴 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 调用ADOConnection组件的GetTableNames方法即可,详见msdn ado帮助 我是用Ado是不Dao。Dao 的方法我也知。用Ado有没有办法? 你可以从sysobjects表中选出,条件是xtype=‘U’ 该范例使用 OpenSchema 方法显示 Pubs 数据库内每个表的名称和类型。Public Sub OpenSchemaX() Dim cnn1 As ADODB.Connection Dim rstSchema As ADODB.Recordset Dim strCnn As String Set cnn1 = New ADODB.Connection strCnn = "Provider=sqloledb;" & _ "Data Source=srv;Initial Catalog=pubs;User Id=sa;Password=; " cnn1.Open strCnn Set rstSchema = cnn1.OpenSchema(adSchemaTables) Do Until rstSchema.EOF Debug.Print "Table name: " & _ rstSchema!TABLE_NAME & vbCr & _ "Table type: " & rstSchema!TABLE_TYPE & vbCr rstSchema.MoveNext Loop rstSchema.Close cnn1.Close End Sub CSDN为什么把回车给去掉了??? Private Sub Form_Load()Dim adoCN As New ADODB.Connection '定义数据库的连接存放数据和代码Dim rstSchemaDim strCnn As New ADODB.Recordset str1 = "Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=wktrade;Data Source=net5" adoCN.Open str1 Set rstSchema = adoCN.OpenSchema(adSchemaTables) Do Until rstSchema.EOF out = out & "Table name: " & _ rstSchema!TABLE_NAME & vbCr & _ "Table type: " & rstSchema!TABLE_TYPE & vbCr rstSchema.MoveNext Loop rstSchema.Close adoCN.CloseDebug.Print outEnd Sub把str写成自己的Access连接 gump2000(阿甘) 的代码好象是Ado帮助里吧。总之谢谢大家了。问题顺利解决 判断FULL OUTER JOIN连接 两个ListVIEW之间清除相同数据问题 谁知道什么叫穷举法?有 菜单为何变成了英文? 请教一个比较低级的问题,怎么样在listview里删除掉所有显示的记录? VB 如何获得网页的源码.不要用组件? 如何用vb(或者vc)做刻录光盘(wzfztw) 文本框的内容插入问题 请问 DataGrid控件能否预先设置好行和列?? 求救,求救,求救,求救,求救,求救(100) !!!!!!!!!!!!!!!!!!!!!!!! 请问:为什么第一张卡片上的控件会出现在所有卡片里面? 在VB中如何传递一个空指针到VC的DLL中?
用Ado有没有办法?
Dim rstSchema As ADODB.Recordset
Dim strCnn As String
Set cnn1 = New ADODB.Connection
strCnn = "Provider=sqloledb;" & _
"Data Source=srv;Initial Catalog=pubs;User Id=sa;Password=; "
cnn1.Open strCnn
Set rstSchema = cnn1.OpenSchema(adSchemaTables)
Do Until rstSchema.EOF
Debug.Print "Table name: " & _
rstSchema!TABLE_NAME & vbCr & _
"Table type: " & rstSchema!TABLE_TYPE & vbCr
rstSchema.MoveNext
Loop
rstSchema.Close
cnn1.Close
End Sub
Dim adoCN As New ADODB.Connection '定义数据库的连接存放数据和代码Dim rstSchema
Dim strCnn As New ADODB.Recordset
str1 = "Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=wktrade;Data Source=net5"
adoCN.Open str1
Set rstSchema = adoCN.OpenSchema(adSchemaTables)
Do Until rstSchema.EOF
out = out & "Table name: " & _
rstSchema!TABLE_NAME & vbCr & _
"Table type: " & rstSchema!TABLE_TYPE & vbCr
rstSchema.MoveNext
Loop
rstSchema.Close
adoCN.Close
Debug.Print out
End Sub
把str写成自己的Access连接
总之谢谢大家了。问题顺利解决