用异步连接 1、首先声明事件 Dim WithEvents Rs As Recordset 2、然后用异步方式打开结果集 Rs.Open "SELECT * FROM 表", Cnn, , , adAsyncFetch 3、在读书记录会触发以下事件 Private Sub Rs_FetchProgress(ByVal Progress As Long, ByVal MaxProgress As Long, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset) '其中Progress:就是当前已取了多少记录 4、当记录全部取完时,会触发 Private Sub Rs_FetchComplete(ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)在去记录的过程中可以做其他事
可以改变鼠标的形状或在状态栏加个loading 之类的字样,表示正在忙着。
1、首先声明事件
Dim WithEvents Rs As Recordset
2、然后用异步方式打开结果集
Rs.Open "SELECT * FROM 表", Cnn, , , adAsyncFetch
3、在读书记录会触发以下事件
Private Sub Rs_FetchProgress(ByVal Progress As Long, ByVal MaxProgress As Long, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
'其中Progress:就是当前已取了多少记录
4、当记录全部取完时,会触发
Private Sub Rs_FetchComplete(ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)在去记录的过程中可以做其他事