当成功连接远程数据库时,输进正确的姓名密码时rs.RecordCount 为-1,输进不正确的姓名密码时rs.RecordCount 也为-1错在哪?
Label4.Caption = "正在登录,请稍候......"
clientWinsock.Protocol = sckTCPProtocol
clientWinsock.RemoteHost = "pcjlqpyf4"
clientWinsock.RemotePort = 4466
clientWinsock.Connect
'连接远程数据库
Dim conn As New adodb.Connection '定义数据库的连接
Set conn = New adodb.Connection
Dim rs As New adodb.Recordset
Set rs = New adodb.Recordset
conn.ConnectionTimeout = 30
conn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;DATABASE=user; User ID=sa;pwd=sa;Data Source=pcjlqpyf4"
rs.Open "select * from userlogin where (( xm='" & Trim(Text1.Text) & " ') and (mm='" & Trim(Text2.Text) & " '))", conn, 3, 3
If rs.RecordCount >0 Then
MsgBox "已登录"
Unload Me
Else
MsgBox "无权登录"
End If
Label4.Caption = "正在登录,请稍候......"
clientWinsock.Protocol = sckTCPProtocol
clientWinsock.RemoteHost = "pcjlqpyf4"
clientWinsock.RemotePort = 4466
clientWinsock.Connect
'连接远程数据库
Dim conn As New adodb.Connection '定义数据库的连接
Set conn = New adodb.Connection
Dim rs As New adodb.Recordset
Set rs = New adodb.Recordset
conn.ConnectionTimeout = 30
conn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;DATABASE=user; User ID=sa;pwd=sa;Data Source=pcjlqpyf4"
rs.Open "select * from userlogin where (( xm='" & Trim(Text1.Text) & " ') and (mm='" & Trim(Text2.Text) & " '))", conn, 3, 3
If rs.RecordCount >0 Then
MsgBox "已登录"
Unload Me
Else
MsgBox "无权登录"
End If
解决方案 »
- 我为什么点按钮没有反应啊!!哪个好心人帮我看看吧!
- 如何用VB ActiveX编写条形码控件
- 关于汽泡式ToolTiptext的问题已困扰我好几天,请大家帮忙!!!!!!!!
- treeview控件问题,怎样确定控件中是否有节点
- 如何把MDI窗体的子窗体右上角的最大最小化屏蔽,但不屏蔽关闭按钮?
- VB的树状控件我搞不定了,来帮帮我吧。(高手快请进!)
- 求救:在水晶报表里,在同一列中,如果相邻的两行数据相同,如何将他们合并成一行?
- 请问有没有办法使MDI窗体不出现标题栏以及最大、最小化按钮?谢!
- 关于使用shell调用外部程序的问题
- 如何在Access中存入图片和文件,如何在控件中显示出
- vb6.0遇到的一个使用问题!!!!急啊!!!
- 祝 MSTOP 生日快乐
rs.cursorlocation=aduseclient --->加這句
rs.Open "select * from userlogin where (( xm='" & Trim(Text1.Text) & " ') and (mm='" & Trim(Text2.Text) & " '))", conn, 3, 3
.......
..
MsgBox "已登录"
Unload Me
Else
MsgBox "无权登录"
End If
MsgBox "已登录"
Unload Me
Else
MsgBox "无权登录"
End If