呵呵,用ADO吧Dim conn As ADODB.Connection
Dim rsP As ADODB.Recordset
Dim rsC As ADODB.RecordsetPrivate Sub CmPro_Click()
If CmPro.ListIndex <> -1 Then
Set rsC = New ADODB.Recordset
rsC.Open "select * from " & CmPro.List(CmPro.ListIndex), conn, adOpenStatic, adLockOptimistic
If rsC.RecordCount > 0 Then
CmCity.Clear
Do Until rsC.EOF
CmCity.AddItem rsC("城市")
rsC.MoveNext
Loop
Else
MsgBox CmPro.List(CmPro.ListIndex) & " 中没有相应的城市"
End If
End If
End SubPrivate Sub Form_Load()
Set conn = New ADODB.Connection
Set rsP = New ADODB.Recordsetconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb;Persist Security Info=False"
conn.OpenrsP.Open "select * from province", conn, adOpenStatic, adLockOptimistic
If rsP.RecordCount > 0 Then
Do Until rsP.EOF
CmPro.AddItem rsP("省")
rsP.MoveNext
Loop
CmPro.Text = CmPro.List(0)End If
End Sub
Dim rsP As ADODB.Recordset
Dim rsC As ADODB.RecordsetPrivate Sub CmPro_Click()
If CmPro.ListIndex <> -1 Then
Set rsC = New ADODB.Recordset
rsC.Open "select * from " & CmPro.List(CmPro.ListIndex), conn, adOpenStatic, adLockOptimistic
If rsC.RecordCount > 0 Then
CmCity.Clear
Do Until rsC.EOF
CmCity.AddItem rsC("城市")
rsC.MoveNext
Loop
Else
MsgBox CmPro.List(CmPro.ListIndex) & " 中没有相应的城市"
End If
End If
End SubPrivate Sub Form_Load()
Set conn = New ADODB.Connection
Set rsP = New ADODB.Recordsetconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb;Persist Security Info=False"
conn.OpenrsP.Open "select * from province", conn, adOpenStatic, adLockOptimistic
If rsP.RecordCount > 0 Then
Do Until rsP.EOF
CmPro.AddItem rsP("省")
rsP.MoveNext
Loop
CmPro.Text = CmPro.List(0)End If
End Sub
另外ComboBox的Style属性最好改成2-DropDownListDim conn As ADODB.Connection
Dim rsP As ADODB.Recordset
Dim rsC As ADODB.RecordsetPrivate Sub CmPro_Click()
If CmPro.ListIndex <> -1 Then
Set rsC = New ADODB.Recordset
rsC.Open "select * from " & Trim(CmPro.List(CmPro.ListIndex)), conn, adOpenStatic, adLockOptimistic
If rsC.RecordCount > 0 Then
CmCity.Clear
Do Until rsC.EOF
CmCity.AddItem rsC("城市")
rsC.MoveNext
Loop
Else
MsgBox CmPro.List(CmPro.ListIndex) & " 中没有相应的城市"
End If
End If
End SubPrivate Sub Form_Load()
Set conn = New ADODB.Connection
Set rsP = New ADODB.Recordsetconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb;Persist Security Info=False"
conn.OpenrsP.Open "select * from province", conn, adOpenStatic, adLockOptimistic
If rsP.RecordCount > 0 Then
Do Until rsP.EOF
CmPro.AddItem rsP("省")
rsP.MoveNext
Loop
CmPro.Text = CmPro.List(0)End If
End Sub
Dim rsP As ADODB.Recordset
Dim rsC As ADODB.RecordsetPrivate Sub CmPro_Click()
If CmPro.ListIndex <> -1 Then
Set rsC = New ADODB.Recordset
rsC.Open "select * from " & Trim(CmPro.List(CmPro.ListIndex)), conn, adOpenStatic, adLockOptimistic
If rsC.RecordCount > 0 Then
CmCity.Clear
Do Until rsC.EOF
CmCity.AddItem rsC("城市")
rsC.MoveNext
Loop
CmCity.Text = CmCity.List(0)
Else
MsgBox CmPro.List(CmPro.ListIndex) & " 中没有相应的城市"
End If
End If
End SubPrivate Sub Form_Load()
Set conn = New ADODB.Connection
Set rsP = New ADODB.Recordsetconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb;Persist Security Info=False"
conn.OpenrsP.Open "select * from province", conn, adOpenStatic, adLockOptimistic
If rsP.RecordCount > 0 Then
Do Until rsP.EOF
CmPro.AddItem rsP("省")
rsP.MoveNext
Loop
CmPro.Text = CmPro.List(0)End If
End Sub
Dim s As String
s = "SELECT * FROM cai WHERE ComputerName='" & DBCombo1.BoundText & "'"
Data2.RecordSource = s
Data2.Refresh
Data2.UpdateControls
End Sub
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb;Persist Security Info=False"
conn.Open
这一句中Data Source=C:\db1.mdb一定要用绝对路径吗?
能不能用相对路径啊?就是和项目放在一起的数据库啊。
不然换个目录又得重新编译哦,好辛苦的。
dbPath=App.path
if right(dbPath,1)<>"\" then
dbPath=dbPath & "\"
end ifconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath & "db1.mdb;Persist Security Info=False"
conn.Open
完全同意 Cooly(Lazy) 的示例程序。