Dim sql As StringDim cnn As New ADODB.Connection
Dim rs As New ADODB.RecordIf Trim(Text1.Text) = "" Then
MsgBox "没有输入用户名", vbOKCancel + vbCritical
Text1.SetFocus
ElseIf Trim(Text2.Text) = "" Then
MsgBox "没有输入密码", vbOKCancel + vbCritical
Text2.SetFocus
Else
cnn.Open "Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True;User ID=sa;Initial Catalog=kn;Data Source=127.0.0.1"
sql = "select * from mytable where myname='"&Trim(Text1.Text)&"' and mypass='"&Trim(Text2.Text)&"'"
rs.Open sql, cnn
If Not rs.RecordCount > 0 Then
Select Case MsgBox("用户名或密码错", vbOKCancel + vbCritical)
Case vbOK
Text1.Text = ""
Text2.Text = ""
Text1.SetFocus
Case Else
End
End Select
Else
b = True
End If
End If
各位高手帮看下,运行后报3709错误,指点下问题出在那
Dim rs As New ADODB.RecordIf Trim(Text1.Text) = "" Then
MsgBox "没有输入用户名", vbOKCancel + vbCritical
Text1.SetFocus
ElseIf Trim(Text2.Text) = "" Then
MsgBox "没有输入密码", vbOKCancel + vbCritical
Text2.SetFocus
Else
cnn.Open "Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True;User ID=sa;Initial Catalog=kn;Data Source=127.0.0.1"
sql = "select * from mytable where myname='"&Trim(Text1.Text)&"' and mypass='"&Trim(Text2.Text)&"'"
rs.Open sql, cnn
If Not rs.RecordCount > 0 Then
Select Case MsgBox("用户名或密码错", vbOKCancel + vbCritical)
Case vbOK
Text1.Text = ""
Text2.Text = ""
Text1.SetFocus
Case Else
End
End Select
Else
b = True
End If
End If
各位高手帮看下,运行后报3709错误,指点下问题出在那
还有你的代码前面是否加了 on error resume next?
Dim rs as Adodb.RecordSet '不应该 是 Adodb.Record