请教大侠!
在VB6中能打开ACCESS数据库,不能在DataGrid控件中显示数据(如在combobox控件中选雇员项或其它项,而在在DataGrid控件中不能显示相应数据)如果你知道原因,请你告诉我好吗?谢谢!!!我界面上设的控件有:Adodc1 ,DataGrid,
combobox ,四个Command控件:open new add cancel
在VB6中能打开ACCESS数据库,不能在DataGrid控件中显示数据(如在combobox控件中选雇员项或其它项,而在在DataGrid控件中不能显示相应数据)如果你知道原因,请你告诉我好吗?谢谢!!!我界面上设的控件有:Adodc1 ,DataGrid,
combobox ,四个Command控件:open new add cancel
Public conn As New ADODB.Connection
Public rs As New ADODB.RecordsetPrivate Sub Form_Load()
Dim strconn As String
strconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;Persist Security Info=False;Jet OLEDB:DataBase Password='123'"
conn.CursorLocation = adUseClient
conn.Open strconn
If rs.State = 1 Then rs.Close
rs.Open "select * from Phonebook", conn, 3, 3
Set Me.DataGrid1.DataSource = rs
rs.MoveFirst
Do While Not rs.EOF
Me.Combo1.AddItem rs("Name")
rs.MoveNext
Loop
End Subconn.CursorLocation = adUseClient這句不能少
如果一定要,改成它就可以了