建议你还是不要用绑定,刷新常出问题,要加refresh的
我是这样用的
Dim rs As Recordset
Set rs = New Recordset
sqlshow = "select * from guest"
rs.Open sqlshow, cn, adOpenStatic, adLockOptimistic
while not rs.eof
list1.additem rs("neirong")
rs.movenext
wend
我是这样用的
Dim rs As Recordset
Set rs = New Recordset
sqlshow = "select * from guest"
rs.Open sqlshow, cn, adOpenStatic, adLockOptimistic
while not rs.eof
list1.additem rs("neirong")
rs.movenext
wend
Private Sub Command4_Click()
Dim cn As Connection
Set cn = New Connection
dbpath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\vb\database.mdb;Persist Security Info=False"
cn.Open dbpath
Dim rs As Recordset
Set rs = New Recordset
sqlshow = "select * from guest"
rs.Open sqlshow, cn, adOpenStatic, adLockOptimisticWhile Not rs.EOF
List1.AddItem = "neirong"
rs.MoveNext
WendEnd Sub
Private Sub Command5_Click()
Dim cn As Connection
Set cn = New Connection
dbpath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\vb\database.mdb;Persist Security Info=False"
cn.Open dbpath
Dim rs As Recordset
Set rs = New Recordset
sqlshow = "select * from login where user='" & Text3.Text & "'"If Not rs.EOF And Not rs.BOF Then
If rs.Fields("pwd") = Text4.Text Then
MsgBox "yes"
Else
MsgBox "no"
End If
Else
MsgBox "no"
End If
End Sub
Dim cn As Connection
Set cn = New Connection
dbpath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\vb\database.mdb;Persist Security Info=False"
cn.Open dbpath
Dim rs As Recordset
Set rs = New Recordset
sqlshow = "select * from login where user='" & Text3.Text & "'"
rs.open sqlshow,cn '*你少了这条语句了。
If Not rs.EOF And Not rs.BOF Then
If rs.Fields("pwd") = Text4.Text Then
MsgBox "yes"
Else
MsgBox "no"
End If
Else
MsgBox "no"
End If
End Sub
rs.open sqlshow,cn,adOpenStatic, adLockOptimistic
你没有把SQL语句发到数据库中去
怎么会返回结果
list1.additem "String"
不应该有"="号