麻烦各位看一下,这是我自己写的代码,为什么连接数据库老有问题
麻烦各位看一下,这是我自己写的代码,为什么连接数据库老有问题
Dim str As String
Dim rst As New ADODB.Recordset
Dim cn As New ADODB.Connection
Private Sub Command1_Click()
Dim conlogin As New ADODB.Connection
Dim rstlogin As New ADODB.Recordset
If Len(Trim(txtUserId.Text)) = 0 Then
MsgBox "用户账号为空,请重新输入!!", vbOKOnly
Exit Sub
End If
If Len(Trim(txtUserName.Text)) = 0 Then
MsgBox "用户姓名为空,请重新输入!!", vbOKOnly
Exit Sub
End If
If Len(Trim(txtUserPsw.Text)) = 0 Then
MsgBox "用户密码为空,请重新输入!!", vbOKOnly
End If
With conlogin
If .State = adStateOpen Then
.Close
End If
.Provider = "SQLOLEDB.1"
.ConnectionString = "User ID=sa;Password=xczhang;Initial Catalog=GaoSuGL;Data Source="
.Open
End With
End Sub
Private Sub txtUserName_Click()
str = "select * from UserLogin where UserId= '" & Text & "' "
Adodc1.RecordSource = str
Adodc1.Refresh
End Sub
小弟不胜感激!