Dim connectstr As String
Dim Rs As New ADODB.Recordset
connectstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
App.Path & "\stocks.mdb;Persist Security Info=False"
Rs.ActiveConnection = connectstr
Rs.Open "select * from paperstocks"
Set DataGrid1.DataSource = Rs '这里出现错误:行集合不能作为标签
Dim connectstr As String
Dim Rs As New ADODB.Recordset
connectstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
App.Path & "\stocks.mdb;Persist Security Info=False"
Rs.ActiveConnection = connectstr
Rs.Open "select * from paperstocks"
Set DataGrid1.DataSource = Rs '这里出现错误:行集合不能作为标签请问原因是什么,如何解决
Dim Rs As New ADODB.Recordset
connectstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
App.Path & "\stocks.mdb;Persist Security Info=False"
Rs.ActiveConnection = connectstr
Rs.Open "select * from paperstocks"
Set DataGrid1.DataSource = Rs '这里出现错误:行集合不能作为标签
Dim connectstr As String
Dim Rs As New ADODB.Recordset
connectstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
App.Path & "\stocks.mdb;Persist Security Info=False"
Rs.ActiveConnection = connectstr
Rs.Open "select * from paperstocks"
Set DataGrid1.DataSource = Rs '这里出现错误:行集合不能作为标签请问原因是什么,如何解决
Set DataGrid1.DataSource = rs请以静态(adOpenStatic)或者键集(adOpenKeyset)的方式打开记录集!!
你没指定,默认的是只向前的记录集(adOpenForwardOnly)的记录集,不能做为DATAGRID的数据源!!
建议你用MSHFlexGrid1控件,它可以!!
根本没有打开数据源!
改为:
Dim connectstr As String
dim cn as new adodb.connection
Dim Rs As New ADODB.Recordset
connectstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
App.Path & "\stocks.mdb;Persist Security Info=False"
cn.open connectstr
Rs.Open "select * from paperstocks",cn,1,3
Set DataGrid1.DataSource = Rs
conn.Open ConnectString
conn.CursorLocation = adUseClientSet rs = New ADODB.Recordset
rs.Open "select * from orders", conn, adOpenDynamic, adLockPessimistic
Set DataGrid1.DataSource = rs