sqlstring = "select * from defect" if rs.state<>adstateclosed then rs.close rs.open sqlstring,db,adopenkeyset,adlockreadonly Set VSFlexGrid1.DataSource = rs
去掉: Set db = New ADODB.Connection Set rs = New ADODB.Recordset 重复VSFlexGrid1.DataRefresh(往后放)放End sub前面试一下
if rs.state<>adstateclosed then rs.close
rs.open sqlstring,db,adopenkeyset,adlockreadonly
Set VSFlexGrid1.DataSource = rs
Set db = New ADODB.Connection
Set rs = New ADODB.Recordset
重复VSFlexGrid1.DataRefresh(往后放)放End sub前面试一下
vsflexgrid1.refresh
试试!