我用VB6.0编写了一个接收数据然后存入SQL2000数据库的一个程序,在接收到上万条数据后,在拖动本系统界面时会显得很慢,请问各位高手这是怎么回事呀?下面是我编写存入数据库的那段代码,请各位高手指点!
Public Sub SaveDataBase()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
On Error GoTo handle
cn.Open "Driver={SQL Server};Server=" & SetForm.Text8.Text & ";" & "Database=Personnellocalizer;Uid=;Pwd="
rs.Open "PersonnelOrientationInfo", cn, adOpenKeyset, adLockOptimistic
rs.AddNew
Text1(0).Text = rs.RecordCount + 1
rs.Fields("ID") = rs.RecordCount
rs.Fields("CardNumber") = Text1(1).Text
rs.Fields("TransceiverStationNumber") = Text1(2).Text
rs.Fields("DataSendTime") = Text1(3).Text
rs.Fields("State") = Text1(4).Text
rs.Fields("Re") = Text1(5).Text
rs.Update
'rs.MoveLast
Label5.Caption = rs.RecordCount
Counter = Counter + 1
MainInceptDataStr = Format(Now, "yyyy-MM-dd HH:mm:ss") & " 正在接收第 " & Counter & " 条数据"
If SetForm.Combo6.Text = "True" Then
Call InceptData
Else
Exit Sub
End If
handle:
On Error GoTo 0
End Sub
Public Sub SaveDataBase()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
On Error GoTo handle
cn.Open "Driver={SQL Server};Server=" & SetForm.Text8.Text & ";" & "Database=Personnellocalizer;Uid=;Pwd="
rs.Open "PersonnelOrientationInfo", cn, adOpenKeyset, adLockOptimistic
rs.AddNew
Text1(0).Text = rs.RecordCount + 1
rs.Fields("ID") = rs.RecordCount
rs.Fields("CardNumber") = Text1(1).Text
rs.Fields("TransceiverStationNumber") = Text1(2).Text
rs.Fields("DataSendTime") = Text1(3).Text
rs.Fields("State") = Text1(4).Text
rs.Fields("Re") = Text1(5).Text
rs.Update
'rs.MoveLast
Label5.Caption = rs.RecordCount
Counter = Counter + 1
MainInceptDataStr = Format(Now, "yyyy-MM-dd HH:mm:ss") & " 正在接收第 " & Counter & " 条数据"
If SetForm.Combo6.Text = "True" Then
Call InceptData
Else
Exit Sub
End If
handle:
On Error GoTo 0
End Sub
解决方案 »
- VB 如何把EXCEL中的数据对应追加插入到ACCESS中啊
- vb 实时错误424,Set conn = Server.CreateObject("ADODB.connection")
- 在不同Excel文件表内容,为什么不能进行粘贴
- 调用EXCEL对象后EXCEL进程无法结束,参考网上的解决办法仍然不行
- 一条Insert Into 语句
- Picture1.Line为什么不能画出来线
- 关于将数据导出到EXcel的问题?急
- 如何让多个程序快同时执行?
- VB Access数据库属性更改或属性设置
- 如何在VB中按比例打印MSChart?
- 请问如何设计最大化form的程序?
- 重装系统后如下程序运行就是致命性错误
修改记录:cn.execute "update tablename set ... where ..."
删除记录:cn.execute "delete from tablename where ..."