Private Sub displayInfo(rs)
lable_id.Caption = rs.Fields(0).Value
iId = rs.Fields(0).Value
strBak(0) = rs.Fields(0)
For i = 1 To 22
If Len(rs.Fields(i)) > 0 Then
Text1(i).Text = rs.Fields(i).Value
strBak(i) = Text1(i).Text
End If
Next i
End Sub这个参数我该怎么写,才最好呢?
lable_id.Caption = rs.Fields(0).Value
iId = rs.Fields(0).Value
strBak(0) = rs.Fields(0)
For i = 1 To 22
If Len(rs.Fields(i)) > 0 Then
Text1(i).Text = rs.Fields(i).Value
strBak(i) = Text1(i).Text
End If
Next i
End Sub这个参数我该怎么写,才最好呢?
有点看不懂你的意思?什么参数?\\
End Sub
Private Sub displayInfo(ByVal subRs As adodb.Recordset)
lable_id.Caption = subRs.Fields(0).Value
iId = subRs.Fields(0).Value
'MsgBox iId
strBak(0) = subRs.Fields(0)
For i = 1 To 22
If Len(subRs.Fields(i)) > 0 Then
Text1(i).Text = subRs.Fields(i).Value
strBak(i) = Text1(i).Text
End If
Next i
End Sub
时保证rs是一个adodb.Recordset
而且已经打开了
Dim rs As adodb.Recordset
Set rs = con.Execute("select * from t_landrent") displayInfo (rs)
End Sub我打开了~~~啊
或
displayInfo rs
试试
lable_id.Caption = rs.Fields(0).Value
iId = rs.Fields(0).Value
strBak(0) = rs.Fields(0)
For i = 1 To 22
If Len(rs.Fields(i)) > 0 Then
Text1(i).Text = rs.Fields(i).Value
strBak(i) = Text1(i).Text
End If
Next i
End Sub
Private Sub displayInfo(byref rs as adodb.recordset)