VB登陆界面连接数据库运行时密码总是错误??

来源:百度知道 编辑:UC知道 时间:2024/05/28 14:23:43
Private Sub Command1_Click()
Dim rs As New ADODB.Recordset '用户信息查询记录集
Dim strSql As String '查询字符串分别存放SQL语句代码段
Dim Conn As New ADODB.Connection '声明并创建ADO Connection对象
Dim CurLoginUserNo As String '保存当前登录的用户编号
Dim CurLoginPassWord As String '保存当前登录的用户名称
'设置连接字符串ConnectionString属性
Conn.ConnectionString = "Provider=SQLOLEDB.1; " & _
"Data Source=127.0.0.1; Initial Catalog=ManageClass; " & _
"User ID=sa; Password="

Conn.Open '打开数据库的连接
'数据有效性检查(未输入用户编号,重新输)
If txtuserid.Text = "" Then
MsgBox "请输入用户编号", vbExclamation + vbOKOnly, "操作提示"
txtuserid.SetFocus '用户编号输入框获得焦点
Exit Sub
End If

'从Users表查询指定用户编号的用户信息
strSql = "SELECT * FROM Users WHERE UserN

Private Sub Command1_Click()
Dim rs As New ADODB.Recordset '用户信息查询记录集
Dim strSql As String '查询字符串分别存放SQL语句代码段
Dim Conn As New ADODB.Connection '声明并创建ADO Connection对象
Dim CurLoginUserNo As String '保存当前登录的用户编号
Dim CurLoginPassWord As String '保存当前登录的用户名称
'设置连接字符串ConnectionString属性
Conn.ConnectionString = "Provider=SQLOLEDB.1; " & _
"Data Source=127.0.0.1; Initial Catalog=ManageClass; " & _
"User ID=sa; Password="

Conn.Open '打开数据库的连接
'数据有效性检查(未输入用户编号,重新输)
If txtuserid.Text = "" Then
MsgBox "请输入用户编号", vbExclamation + vbOKOnly, "操作提示"
txtuserid.SetFocus '用户编号输入框获得焦点
Exit Sub
End If

'从Users表查询指定用户编号的用户信息
strSql = "SELECT * FROM Users WHERE UserNo='" & txtuserid.Text & "'"
rs.Open strSql, Conn, adOpenStatic, adLockReadOnly
If rs.Record