Set Datagrid1.Datasource = <Recordset> Datagrid1.refresh
to NewPeople(新新人类)>: 出现错误'7004': 行集合不能作为标签 各位大侠能给出能正确运行的代码吗?
Dim ros As ADODB.Recordset Dim p_con As ADODB.Connection Public Sub aa() Set ros = New ADODB.Recordset
ros.Open "table", p_con
Set Me.DataGrid1.DataSource = ros
ros.Requery End Sub 在连接数据库的时候要把p_con。CursorLocation设置成服务器才能正常读取数据
大家看看下面的代码有哪里不对吗? Dim Con As ADODB.Connection Dim Rs As ADODB.Recordset Set Con = New ADODB.Connection Con.CursorLocation = adUseServer Set Rs = New ADODB.Recordset Set Rs = DBcn.Execute("Select * from Member") DataGrid1.DataSource = Rs 怎么这个datasource总是报错:"未找到方法或数据成员"??
Datagrid1.refresh
出现错误'7004':
行集合不能作为标签
各位大侠能给出能正确运行的代码吗?
Dim p_con As ADODB.Connection
Public Sub aa()
Set ros = New ADODB.Recordset
ros.Open "table", p_con
Set Me.DataGrid1.DataSource = ros
ros.Requery
End Sub
在连接数据库的时候要把p_con。CursorLocation设置成服务器才能正常读取数据
Dim Con As ADODB.Connection
Dim Rs As ADODB.Recordset
Set Con = New ADODB.Connection
Con.CursorLocation = adUseServer
Set Rs = New ADODB.Recordset
Set Rs = DBcn.Execute("Select * from Member")
DataGrid1.DataSource = Rs
怎么这个datasource总是报错:"未找到方法或数据成员"??
应该是这个问题
set datagrid1.datasource=rs
我想这样就行了吧