我通过MSHFlexgrid 通过条件查记录,记录大概有一万4000条,速度需要1分半,太慢,并且第二次查询时,记录只与最后一行,前面都空白
代码如下:Private Sub title1()
Dim L As Integer
m = Array(700, 1500, 1500, 1500, 1500, 1500, 1500, 1500, 1500, 1500)
n = Array("序号", "工程号", "图档号", "板号", "条码", "尺寸", "颜色", "备注栏", "制程", "工作站")
For L = 0 To 9
MS1.ColWidth(L) = m(L): MS1.TextMatrix(0, L) = n(L)
Next LEnd Sub
Private Sub Command1_Click()
MS1.Clear
Call title1
Adodc1.ConnectionString = PublicStrAdodc1.RecordSource = "select * from scandata where 1=1"
If Text1.Text <> "" Then
Adodc1.RecordSource = Adodc1.RecordSource + " and gch='" + Text1.Text + "'"
End IfIf Text2.Text <> "" Then
Adodc1.RecordSource = Adodc1.RecordSource + " and tdh='" + Text2.Text + "'"
End If
Adodc1.Refresh
Text3.Text = Adodc1.Recordset.RecordCountIf Adodc1.Recordset.RecordCount > 0 Then Do While Adodc1.Recordset.EOF = False
MS1.Rows = Adodc1.Recordset.RecordCount + 1
On Error Resume Next
MS1.TextMatrix(MS1.Row, 1) = Adodc1.Recordset.Fields("gch")
MS1.TextMatrix(MS1.Row, 2) = Adodc1.Recordset.Fields("tdh")
MS1.TextMatrix(MS1.Row, 3) = Adodc1.Recordset.Fields("bh")
MS1.TextMatrix(MS1.Row, 4) = Adodc1.Recordset.Fields("barcode")
MS1.TextMatrix(MS1.Row, 5) = Adodc1.Recordset.Fields("cc")
MS1.TextMatrix(MS1.Row, 6) = Adodc1.Recordset.Fields("ys")
MS1.TextMatrix(MS1.Row, 7) = Adodc1.Recordset.Fields("bzl")
MS1.TextMatrix(MS1.Row, 8) = Adodc1.Recordset.Fields("zc")
MS1.TextMatrix(MS1.Row, 9) = Adodc1.Recordset.Fields("stationName")
Adodc1.Recordset.MoveNext
j = j + 1
MS1.AddItem (j)
MS1.Row = MS1.Row + 1
Loop End IfFor i = 1 To MS1.Rows
MS1.TextMatrix(i, 0) = i
Next i
End SubPrivate Sub Form_Load()
Call title1End Sub
MSHFLEXGRID
解决方案 »
- VB6,DLL工程,内附二个Form,他俩之间如何沟通?
- 如何让的DOS窗口获得鍵盤焦点?
- 有关Format的简单问题~
- QQQQQQQQQQQQQQQ............搜索排行榜第一(权当散分)?
- 怎么样,调出 OLEDB的数据连接属性对话框?
- 急!如何将imgscan扫描出来的图存为jpg文件!!
- 关于菜单使用的一个简单问题,在线等。
- 如何用VB做关机程序(详细)?加分100
- 在VB中如何求得一个类型的长度?例如我定义了一个sockaddr类型的变量色server,怎样求得server的长度?
- 用VB 控制数码相机,或读取其中的相片?请给点资料!
- 关于SUBCLASS的问题
- 怎么在四天里 完成VB快速入门。
set ms1.datasource=adodc1.recordset
end if
实时错误91,对象变量或WITH块变量末设置
set ms1.datasource=adodc1.recordset 变黄
......
Adodc1.Refresh
If Adodc1.Recordset.RecordCount > 0 Then
set ms1.datasource=adodc1.recordset
end if
Call title1
Adodc1.ConnectionString = PublicStrAdodc1.RecordSource = "select * from scandata where 1=1"
If Text1.Text <> "" Then
Adodc1.RecordSource = Adodc1.RecordSource + " and gch='" + Text1.Text + "'"
End IfIf Text2.Text <> "" Then
Adodc1.RecordSource = Adodc1.RecordSource + " and tdh='" + Text2.Text + "'"
End If
Adodc1.Refresh
'Text3.Text = Adodc1.Recordset.RecordCount
'
If Adodc1.Recordset.RecordCount > 0 Then
Set MS1.DataSource = Adodc1
MS1.Rows = Adodc1.Recordset.RecordCount + 1
End If
End SubPrivate Sub Form_Load()
Call title1End Sub
Private Sub title1()
Dim L As Integer
m = Array(700, 1500, 1500, 1500, 1500, 1500, 1500, 1500, 1500, 1500)
n = Array("序号", "工程号", "图档号", "板号", "条码", "尺寸", "颜色", "备注栏", "制程", "工作站")
For L = 0 To 9
MS1.ColWidth(L) = m(L): MS1.TextMatrix(0, L) = n(L)
Next LEnd Sub还是没用 错误继续是实时错误91,对象变量或WITH块变量末设置
对了意思,我的控件是msflexgrid 不是mshflexgrid 这两种有什么区别?
谢谢