Private Sub cmdOK_Click()
Dim n
n = 0
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim cmd As ADODB.Command
Set cnn = New ADODB.Connection
Set rst = New ADODB.Recordset
Set cmd = New ADODB.Command
cnn.ConnectionString = "DSN=material;UID=sa;PWD=admin"
cnn.Open
Set cmd.ActiveConnection = cnn
cmd.CommandText = "select * from [user] where username='" + Me.txtUserName.Text + "'and password='" + Me.txtPassword.Text + "'"Set rst = cmd.ExecuteIf n = 3 Then
MsgBox "您尝试的次数超过三次,系统将自动关闭", 0, "警告"
End
End If
If rst.RecordCount > 0 Then
OK = True
Me.Hide
Else
MsgBox "您的用户名或密码有误,请核对好重新输入", 0, "警告"
n = n + 1
End IfEnd Sub我输入数据库里面正确的用户名和密码,都提示用户名或密码有误,而且尝试次数超过三次也不自动退出,请问这是怎么回事?输入错误的用户名和密码也是一样提示用户名或密码有误
Dim n
n = 0
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim cmd As ADODB.Command
Set cnn = New ADODB.Connection
Set rst = New ADODB.Recordset
Set cmd = New ADODB.Command
cnn.ConnectionString = "DSN=material;UID=sa;PWD=admin"
cnn.Open
Set cmd.ActiveConnection = cnn
cmd.CommandText = "select * from [user] where username='" + Me.txtUserName.Text + "'and password='" + Me.txtPassword.Text + "'"Set rst = cmd.ExecuteIf n = 3 Then
MsgBox "您尝试的次数超过三次,系统将自动关闭", 0, "警告"
End
End If
If rst.RecordCount > 0 Then
OK = True
Me.Hide
Else
MsgBox "您的用户名或密码有误,请核对好重新输入", 0, "警告"
n = n + 1
End IfEnd Sub我输入数据库里面正确的用户名和密码,都提示用户名或密码有误,而且尝试次数超过三次也不自动退出,请问这是怎么回事?输入错误的用户名和密码也是一样提示用户名或密码有误
解决方案 »
- webbrowser 跨域 拒绝访问的问题
- 用WINSOCK.bind出现实时错误87
- 请教一个dsn文件的问题。。。。。
- QQ大秘密,不信你也试试
- wise installer打包时,如何将文件拷贝时的“wise 安装向导”(进度条下)改掉?
- Access中的长日期型对应于SQL Server的什么类型?在线等
- 如何判断用户本地机上有没有安装某一程序………………?
- 新春快乐&发布一款刚刚写好的软件,大家捧场!
- 请问你们在网上拷vb 的源程序来运行时, 是不是经常有错误的?例如:
- ADO问题!!!
- 请问vb连接sql语句时,drive、server、UID等这写应该填写什么内容?
- 为什么输出的值在不同的机器上不一样
改为
sql="select * from [user] where username='" + Me.txtUserName.Text + "'and password='" + Me.txtPassword.Text + "'"
rs.open sql,conn,1,1
Dim rst As ADODB.Recordset
cnn.ConnectionString = "DSN=material;UID=sa;PWD=admin"
cnn.Open
rst.Open "select * from [user] where username='" + Me.txtUserName.Text + "'and password='" + Me.txtPassword.Text + "'",cnn, adOpenDynamic, adLockOptimisticif rst.eof then
MsgBox "您的用户名或密码有误,请核对好重新输入", 0, "警告"
n = n + 1
If n = 3 Then
MsgBox "您尝试的次数超过三次,系统将自动关闭", 0, "警告"
End
End Ifelse
frmMain.show
end if