|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
我想做个窗体的用户登录,调取SQL数据库的Users数据表,根据用户名与密码与Users表对应,正确就登录成功,可是我设的代码老提示数据类型不一致,不知道具体是哪里出了问题!
Private Sub CommandButton1_Click()
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim u, p As Variant
Dim sql As String
u = TextBox1.Text
p = TextBox2.Text
cnn.ConnectionString = "Provider=SQLOLEDB;" _
& "User ID=sa;" _
& "Password =11111;" _
& "Data Source=XXXXXX;"_
& "Initial Catalog =renshi;"
cnn.Open
sql = "select password from users where pinyin='" & u & "' or name='" & u & "'"
Set rs = cnn.Execute(sql)
If p = rs Then
MsgBox "登录成功!", 1 + 64, "系统登陆"
Else
MsgBox "哎呀,你填错了!", 1 + 64, "系统登陆"
End If
End Sub |
|