在线等:mshflexgrid控件绑定记录集,实时刷新数据,表格无法下拉问题。
euan 2005-03-25 04:10:50 dim adoRecordset As Recordset
dim db As Connection
dim CN As New ADODB.Connection
dim rs1 As ADODB.Recordset
Private Sub Form_Load()
CN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=d:\db.mdb"
CN.Open
Set rs1 = New Recordset
rs1.Open "select * from device1", CN, adOpenDynamic, adLockOptimistic
Set Grid1.DataSource = rs1
Grid1.ColWidth(0) = 800
Grid1.ColWidth(1) = 2000
Grid1.ColWidth(2) = 2500
Grid1.ColWidth(3) = 2000
End Sub
Private Sub UpdateTagSubset()
Dim i As Integer
Dim j As Integer
If Not rs1.EOF Then
rs1.MoveFirst
For i = 1 To m_appDeviceCount
For j = 1 To m_nvCount
rs1!value = m_deviceArray(i, j ).value
rs1.Update
Set Grid.DataSource=Nothing
Set Grid.DataSource=rs1
Grid1.Refresh
rs1.MoveNext
Next
Next
End If
Exit Sub
End Sub
还有
UpdateTagSubset()这个过程我用的是定时器来不断的更新数值的,请大侠帮忙啊!!!
Private Sub timeNV_Timer()
UpdateTagSubset
Exit Sub
End Sub
真的非常感谢各位给我的帮助,Gutta(冯大狂),vbman2003(家人),leayh(云卷云舒)
表格数据可以刷新了,但是我同时又发现了新的问题,我需要实时更新的有56个监控点,因为数据比较多所以表格右面有下拉条,这时候我发现在表格上刷新的同时,是无法下拉的,是不是因为我定时器设的时间间隔比较小啊,我设的interval是500的,那么这个是不是VB自身带来的问题,因为它不支持多线程,我现在不知道有什么措施可以改进,请大家帮我出出主意,