7,763
社区成员
发帖
与我相关
我的任务
分享
Private Sub Form_Load()
cn.Open constr
rs.CursorLocation = adUseClient
rs.Open "select * from aaa", cn, adOpenKeyset, adLockOptimistic
Set DataGrid1.DataSource = Nothing
Set DataGrid1.DataSource = rs
‘rs.close 这两行不能加,加了datagrid就没有数据
'cn.close 这两行不能加,
End Sub
Private Sub Form_Load()
cn.CursorLocation = adUseClient
cn.Open constr
rs.Open "select * from aaa", cn, adOpenKeyset, adLockOptimistic
Set DataGrid1.DataSource = rs
cn.close
set rs.activateconnection=nothing
set datagrid1.datasource=rs
End Sub
Private Sub Form_Load()
cn.CursorLocation = adUseClient
cn.Open constr
' rs.CursorLocation = adUseClient
rs.Open "select * from aaa", cn, adOpenKeyset, adLockOptimistic
' Set DataGrid1.DataSource = Nothing
Set DataGrid1.DataSource = rs
‘rs.close 这两行不能加,加了datagrid就没有数据
'cn.close 这两行不能加, 此句应该没有问题,上面那个不能加
set rs.activateconnection=nothing
End Sub