vb和sql的问题啊?
想用vb做个系统登陆界面,用的是sql数据库
字段设置为char
然后在vb中设置了两个文本框text用来输入用户名和密码,但是在做比较的时候为什么老是说不等呢??
大概代码如下:
Private Sub Command1_Click()
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
cn.ConnectionString = "DSN=library;UID=;PWD=;"
'cn.ConnectionTimeout = 30
cn.Open
Set rs = New Recordset
rs.Open "select * from user_manager", cn
If text1.Text = "" Then
MsgBox "请填写用户名!", vbOKOnly + vbInformation, "注意"
text1.SetFocus
Exit Sub
ElseIf text2.Text = "" Then
MsgBox "请填写密码!", vbOKOnly + vbInformation, "注意"
text2.SetFocus
Exit Sub
End If
mingzi = rs("username")
mima = rs("pwd")
If (text1.Text <> mingzi) Then
Print "用户名不对"
Else
Print "用户名正确"
End If
End Sub