VB for循环,怎么实现显示检索出来的所有数据 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim Cnn As New ADODB.Connection '定义数据链接对象,保存连接数据库信息;请先添加ADO引用
Dim Rs As New ADODB.Recordset '定义记录集对象,保存数据表 MsgBox(3)
Dim strCnn = "Provider=SQLNCLI;Server=服务大众;Database=qzsyck;Trusted_Connection=yes;"
Cnn.Open(strCnn) MsgBox("链接成功") Rs.Open("select * from userpw", Cnn) '定义SQL查询命令字符串 For i = 1 To 4 MsgBox(Rs("user").Value)
MsgBox(Rs("password").Value) Next i
'循环
Rs.Close()
Cnn.Close()
End Subfor循环里面该怎么写?附上我的数据库id user passwoed
1 aa 123
2 tt 21
3 sa 31
4 ae qweqe
Dim Rs As New ADODB.Recordset '定义记录集对象,保存数据表 MsgBox(3)
Dim strCnn = "Provider=SQLNCLI;Server=服务大众;Database=qzsyck;Trusted_Connection=yes;"
Cnn.Open(strCnn) MsgBox("链接成功") Rs.Open("select * from userpw", Cnn) '定义SQL查询命令字符串 For i = 1 To 4 MsgBox(Rs("user").Value)
MsgBox(Rs("password").Value) Next i
'循环
Rs.Close()
Cnn.Close()
End Subfor循环里面该怎么写?附上我的数据库id user passwoed
1 aa 123
2 tt 21
3 sa 31
4 ae qweqe
set mshflexgrid.datasource=rs
rs.Close()
cnn.Close()
do until rs.eof
MsgBox(Rs("user").Value)
MsgBox(Rs("password").Value)
rs.movenext
loop
For i = 1 To rs.RecordCount
MsgBox(Rs("user").Value) & " " & Rs("password").Value
rs.movenext
Next i
'------------------------------
For i = 1 To rs.RecordCount
debug.print Rs("user").Value & " " & Rs("password").Value
rs.movenext
Next i
用处是记录指针移动到下一条