Dim cn As New adodb.Connection
Dim rs As New adodb.Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & App.Path & "\db\salary.mdb;"
rs.Open "select * from Manger where LoginName='" & txtLoginName & "'", cnSet DataGrid1.DataSource = rs '该行错误。
Dim rs As New adodb.Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & App.Path & "\db\salary.mdb;"
rs.Open "select * from Manger where LoginName='" & txtLoginName & "'", cnSet DataGrid1.DataSource = rs '该行错误。
这样试试
Dim rs As New adodb.Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & App.Path & "\db\salary.mdb;"
rs.Open "select * from Manger where LoginName='" & txtLoginName & "'", cn
'看看rs的状态
debug.print rs.state=adstateopen
Set DataGrid1.DataSource = rs '该行错误。
rs.open YourSQLStatements,cn,1,3
Dim rs As New adodb.Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & App.Path & "\db\salary.mdb;"
rs.CursorLocation = adUseClient
rs.Open "select * from Manger where LoginName='" & txtLoginName & "'", cn, adOpenDynamic, adLockBatchOptimisticSet DataGrid1.DataSource = rs
rs.CursorLocation = adUseClient
呵呵,当初我也出过这样的问题
Dim rs As New adodb.Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & App.Path & "\db\salary.mdb;"rs.CursorLocation = adUseClient'注意这一句,要使用客户端游标rs.Open "select * from Manger where LoginName='" & txtLoginName & "'", cn, adOpenDynamic, adLockBatchOptimisticSet DataGrid1.DataSource = rs
datagrid1.refresh