语句为： Set Frmshow.DataGrid1.DataSource = rs---错误为：行集合不支持标签---我是想用另一个窗体的datagrid显示数据

[hoge66]

语句为： Set Frmshow.DataGrid1.DataSource = rs---错误为：行集合不支持标签---我是想用另一个窗体的datagrid显示数据。请高手指点！

[strongfisher]

Set form1.dgAsset.DataSource = Nothing
Set rs = New ADODB.Recordset
With rs
.CursorType = adOpenDynamic
.CursorLocation = adUseClient
.LockType = adLockPessimistic
.Source = "SELECT * FROM tblasset"
Set .ActiveConnection = cnnCMMS
.Open
End With
Set form1.dgAsset.DataSource = rs
应该可以的

[lihonggen0]

Rs.CursorLocation = adUseClient '加一句

Rs.Open "select * from employees", CN, adOpenDynamic, adLockBatchOptimistic

Set DataGrid1.DataSource = Rs