我的代码如下,为什么DATAGRID中不显示内容
Option Explicit
Dim cat As New ADOX.Catalog
Dim conn As New ADODB.Connection
Dim RS As New ADODB.Recordset
Dim pstr As String
Dim RS As ADODB.Recordset
Dim strsql As String
pstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\feita.mdb;Persist Security Info=False"
conn.Open pstr
Set RS = New ADODB.Recordset
strsql = "select * from k"
RS.Open strsql, conn, adOpenKeyset, adLockOptimistic, adCmdText
RS.Close
conn.Close
Set DataGrid1.DataSource = RS
DataGrid1.Refresh
Option Explicit
Dim cat As New ADOX.Catalog
Dim conn As New ADODB.Connection
Dim RS As New ADODB.Recordset
Dim pstr As String
Dim RS As ADODB.Recordset
Dim strsql As String
pstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\feita.mdb;Persist Security Info=False"
conn.Open pstr
Set RS = New ADODB.Recordset
strsql = "select * from k"
RS.Open strsql, conn, adOpenKeyset, adLockOptimistic, adCmdText
RS.Close
conn.Close
Set DataGrid1.DataSource = RS
DataGrid1.Refresh
RS.Close
conn.Close
看看吧。
Option Explicit
Dim cat As New ADOX.Catalog
Dim conn As New ADODB.Connection
Dim RS As New ADODB.Recordset
Dim pstr As String
Dim RS As ADODB.Recordset
Dim strsql As String
pstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\feita.mdb;Persist Security Info=False"
conn.Open pstr
Set RS = New ADODB.Recordset
strsql = "select * from k"
RS.Open strsql, conn, adOpenKeyset, adLockOptimistic, adCmdTextSet DataGrid1.DataSource = RS
DataGrid1.Refresh
RS.Close:set rs=nothing
conn.Close:set conn=nothing
conn.CursorLocation = adUseClient
RS.Close:set rs=nothing
conn.Close:set conn=nothing