Private Sub LtsC(sx As String) Dim r As Long Dim sBuffer As String MyRs.Open "select * from sms order by id desc", MyDb, adOpenStatic, adLockReadOnly If MyRs.RecordCount > 0 Then r = 0 Do While Not MyRs.EOF Call hanggao sBuffer = "" r = r + 1 sBuffer = Chr(32) & r & "." sBuffer = sBuffer & "【" & MyRs!classname & "】" & Chr(32) & MyRs!smscontent & vbCrLf ShowText.SelColor = vbBlack ShowText.SelStart = &H7FFFFFFF ShowText.SelText = sBuffer ShowText.SelColor = &H80FF& ShowText.SelStart = &H7FFFFFFF ShowText.SelText = "------------------------------------------------------------------------------------------------" & vbCrLf
MyRs.MoveNext Loop
zjls.Caption = MyRs.RecordCount '显示总记录数 MyRs.Close ShowText.SelStart = 1 '焦点回到首行 Else MyRs.Close End If
Dim r As Long
Dim sBuffer As String MyRs.Open "select * from sms order by id desc", MyDb, adOpenStatic, adLockReadOnly
If MyRs.RecordCount > 0 Then
r = 0
Do While Not MyRs.EOF
Call hanggao
sBuffer = ""
r = r + 1
sBuffer = Chr(32) & r & "."
sBuffer = sBuffer & "【" & MyRs!classname & "】" & Chr(32) & MyRs!smscontent & vbCrLf
ShowText.SelColor = vbBlack
ShowText.SelStart = &H7FFFFFFF
ShowText.SelText = sBuffer
ShowText.SelColor = &H80FF&
ShowText.SelStart = &H7FFFFFFF
ShowText.SelText = "------------------------------------------------------------------------------------------------" & vbCrLf
MyRs.MoveNext
Loop
zjls.Caption = MyRs.RecordCount '显示总记录数
MyRs.Close
ShowText.SelStart = 1 '焦点回到首行
Else
MyRs.Close
End If
End Sub