工程->引用->Micorosoft Activex Data Object 2.0 Library(后面为版本号)Public cn1 As New ADODB.Connection, rs As New ADODB.RecordsetIf cn1.State = adStateOpen Then cn1.Close
Do Until rs.EOF If Trim(rs!TABLE_TYPE) = "TABLE" Then lstTable1.AddItem Trim(rs!TABLE_NAME) rs.MoveNext Loop
rs.Close Set rs = Nothing===========================================为上以前做的一个程序里的代码,是将表名称添加到LISTBOX控件里,你自己看看吧,希望对你有帮助!!
Dim cat As ADOX.Catalog Dim cnn As ADODB.Connection Dim tbl As ADOX.Table Set cat = New ADOX.Catalog Set cnn = New ADODB.Connection cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Text1.Text Set cat.ActiveConnection = cnn Combo1.Clear On Error Resume Next For Each tbl In cat.Tables If Left(tbl.Name, 4) <> "MSys" Then Combo1.AddItem tbl.Name End If Next Set cat = Nothing Set Con = Nothing
'返回数据库里的所有表名。需要一个Combo控件 Public Sub AllTableName(cmbTableName As ComboBox) Dim i As Integer
Set rc = New ADODB.Recordset Set rc = cn.OpenSchema(adSchemaTables)
i = 0
Do While Not rc.EOF
If rc!TABLE_TYPE = "TABLE" Then If i = 0 Then cmbTableName.Text = rc!TABLE_NAME End If cmbTableName.AddItem rc!TABLE_NAME i = i + 1 End If rc.MoveNext Loop rc.Close
'引用微软 ADO Ext.2.7 for dll and Security Dim cat As ADOX.Catalog Dim cnn As ADODB.Connection Dim tbl As ADOX.TablePrivate Sub Command1_Click() On Error Resume Next For Each tbl In cat.Tables If Left(tbl.Name, 4) <> "MSys" Then List1.AddItem tbl.Name End If Next End SubPrivate Sub Form_Load() Set cnn = New ADODB.Connection Set cat = New ADOX.Catalog cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\csdn_vb\database\treeview的节点添加\article.mdb" Set cat.ActiveConnection = cnn End SubPrivate Sub Form_Unload(Cancel As Integer) Set cat = Nothing Set con = Nothing End SubPrivate Sub List1_Click() Dim fld Dim intfield As Integer List2.Clear intfield = cat.Tables(List1.List(List1.ListIndex)).Columns.Count For i = 0 To intfield - 1 Set fld = cat.Tables(List1.List(List1.ListIndex)).Columns(i) List2.AddItem fld.Name Next End Sub
cn1.ConnectionString = "dsn=" & cboDSN1.Text & ";uid=" & txtUID1.Text & ";pwd=" & txtPWD1.Text
cn1.Open
Set rs = cn1.OpenSchema(adSchemaTables)
lstTable1.Clear
lblStatus1.Caption = "数据源连接成功,正在检索数据表..."
DoEvents
Do Until rs.EOF
If Trim(rs!TABLE_TYPE) = "TABLE" Then lstTable1.AddItem Trim(rs!TABLE_NAME)
rs.MoveNext
Loop
rs.Close
Set rs = Nothing===========================================为上以前做的一个程序里的代码,是将表名称添加到LISTBOX控件里,你自己看看吧,希望对你有帮助!!
Dim cnn As ADODB.Connection
Dim tbl As ADOX.Table
Set cat = New ADOX.Catalog
Set cnn = New ADODB.Connection
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Text1.Text
Set cat.ActiveConnection = cnn
Combo1.Clear
On Error Resume Next
For Each tbl In cat.Tables
If Left(tbl.Name, 4) <> "MSys" Then
Combo1.AddItem tbl.Name
End If
Next
Set cat = Nothing
Set Con = Nothing
Public Sub AllTableName(cmbTableName As ComboBox) Dim i As Integer
Set rc = New ADODB.Recordset
Set rc = cn.OpenSchema(adSchemaTables)
i = 0
Do While Not rc.EOF
If rc!TABLE_TYPE = "TABLE" Then
If i = 0 Then
cmbTableName.Text = rc!TABLE_NAME
End If
cmbTableName.AddItem rc!TABLE_NAME
i = i + 1
End If
rc.MoveNext
Loop
rc.Close
End Sub
Dim cat As ADOX.Catalog
Dim cnn As ADODB.Connection
Dim tbl As ADOX.TablePrivate Sub Command1_Click()
On Error Resume Next
For Each tbl In cat.Tables
If Left(tbl.Name, 4) <> "MSys" Then
List1.AddItem tbl.Name
End If
Next
End SubPrivate Sub Form_Load()
Set cnn = New ADODB.Connection
Set cat = New ADOX.Catalog
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\csdn_vb\database\treeview的节点添加\article.mdb"
Set cat.ActiveConnection = cnn
End SubPrivate Sub Form_Unload(Cancel As Integer)
Set cat = Nothing
Set con = Nothing
End SubPrivate Sub List1_Click()
Dim fld
Dim intfield As Integer
List2.Clear
intfield = cat.Tables(List1.List(List1.ListIndex)).Columns.Count
For i = 0 To intfield - 1
Set fld = cat.Tables(List1.List(List1.ListIndex)).Columns(i)
List2.AddItem fld.Name
Next
End Sub
online(龙卷风V2.0--再战江湖) -------------70 非常详细
: liaorui(更烦得很~ξ)---------------------15
haohaohappy() -----------------------------10
cuizm(射天狼) -----------------------------5