为什么说我时时错误

来源:百度知道 编辑:UC知道 时间:2024/05/15 18:13:03
Private Sub ShowData()
Dim txtSQL As String
Dim mrc As ADODB.Recordset
txtSQL = "select * from class_Form"
Set mrc = ExecuteSQL(txtSQL, MsgText)
With MSFlexGrid1
MSFlexGrid1.ColWidth(0) = 1200
MSFlexGrid1.ColWidth(1) = 1200
MSFlexGrid1.ColWidth(2) = 1200
MSFlexGrid1.ColWidth(3) = 6000
MSFlexGrid1.TextMatrix(0, 0) = "班级编号"
MSFlexGrid1.TextMatrix(0, 1) = "班级名称"
MSFlexGrid1.TextMatrix(0, 2) = "导员姓名"
MSFlexGrid1.TextMatrix(0, 3) = "备注信息"
MSFlexGrid1.Rows = 1
Do While Not mrc.EOF ( 是不是这错了??????)
.Rows = .Rows + 1
For i = 0 To mrc.Fields.Count - 1
.TextMatrix(.Rows - 1, i) = mrc.Fields(i) & ""
Next i
mrc.MoveNext
Loop
End With
mrc.Close

Dim mrc As ADODB.Recordset 改成Dim mrc As new ADODB.Recordset
或者在Dim mrc As ADODB.Recordset后面加set mrc=new ADODB.Recordset

With MSFlexGrid1
MSFlexGrid1.ColWidth(0) = 1200
MSFlexGrid1.ColWidth(1) = 1200
MSFlexGrid1.ColWidth(2) = 1200
MSFlexGrid1.ColWidth(3) = 6000
MSFlexGrid1.TextMatrix(0, 0) = "班级编号"
MSFlexGrid1.TextMatrix(0, 1) = "班级名称"
MSFlexGrid1.TextMatrix(0, 2) = "导员姓名"
MSFlexGrid1.TextMatrix(0, 3) = "备注信息"
MSFlexGrid1.Rows = 1
……………………
使用了with MSFlexGrid1之后,下面的要去掉MSFlexGrid1,改成
With MSFlexGrid1
.ColWidth(0) = 1200
.ColWidth(1) = 1200
.ColWidth(2) = 1200
.ColWidth(3) = 6000
.TextMatrix(0, 0) = "班级编号"
.TextMatrix(0, 1) = "班级名称"
.TextMatrix(0, 2) = "导员姓名"
.TextMatrix(0, 3) = "备注信息"
.Rows = 1
…………………………