先关闭,再打开
If DataEnvironment1.rsCommand1.State = adStateOpen Then
DataEnvironment1.rsCommand1.Close
End If
DataEnvironment1.rsCommand1.open
If DataEnvironment1.rsCommand1.State = adStateOpen Then
DataEnvironment1.rsCommand1.Close
End If
DataEnvironment1.rsCommand1.open
for i=1 to 100 '加入100条新记录
DataEv1.rsCmdDstmp.AddNew
DataEv1.rsCmdDstmp("No") =i
DataEv1.rsCmdDstmp.Update
NextIf DataEv1.rsCmdDstmp.State = adStateOpen Then
DataEv1.rsCmdDstmp.Close
End If
DataEv1.rsCmdDstmp.OpenMShflexgrid1.Refresh
(为何加入的100条新记录在MSFLEXGRID未显示出来?)
DataEv1.rsCmdDstmp.State = adStateOpen ?
确认 DataEv1.rsCmdDstmp.Close?
基本用法set MSHFlexGrid1.recordset=adodb