如同一个登录窗口
解决方案 »
- 关于vb分割图片问题~~~~求高手解决
- 怎么在将datagrid中的数据导出Excel到时加上表头,谁有代码啊??
- VBA加密问题!!!
- 诚交江苏南通的VB朋友们,加我QQ:58438619,详谈!
- 请问如何让一个程序在一台机子安装运行后,不能再在别的机子上使用?
- 在VB中使用的水晶报表控件如何连接到数据库?在线等待!
- 给excel工作簿加密码的问题!
- 求救,用VB发送和接收数据
- ado中删除记录的问题--急
- 请问VB生成的DLL如何能注册成功,我试着用REGSVR32提示我成功了,可没法调用?
- :( eMbedded Visual Tools 刚下的,注册码怎么得到?谢谢
- 〓〓>-→ 控件引用的简单问题,高手菜鸟都来看看吧。
Dim userName As String
Dim userPass As String
Dim CN As New ADODB.Connection
Dim Rs As New ADODB.Recordset
userName = Trim(text1.Text)
userPass = Trim(text2.Text)
Set CN = CreateObject("adodb.connection")
CN.open "provider=microsoft.jet.oledb.4.0;data source=" & App.path & "\system.mdb"
sql = "select * from member where username='" & userName & "' and userpass='" & userPass & "'"
Rs.CursorLocation = adUseClient
Rs.open sql, CN, adOpenDynamic, adLockReadOnly
If Rs.RecordCount > 0 Then
MsgBox "进入系统", vbOKOnly + vbInformation, "系统消息"
Else
MsgBox "对不起,登录错误"
End IfEnd Sub
Dim rsADO As ADODB.RecordsetPrivate Sub cmdLogin_Click()
Dim strSQL As String
Set cnADO = New ADODB.Connection
Set rsADO = New ADODB.Recordset
cnADO.CursorLocation = adUseClient
cnADO.Open ConnectionString
strSQL = "Select * From LoginUsers where UserID = '" & Trim(txtUserID.Text) & "' And Password = '" & Trim(txtPassword.Text) & "'"
rsADO.Open strSQL, cnADO, adOpenStatic, adLockReadOnly
If rsADO.EOF Then
MsgBox "你沒有權限使用本系統!", vbCritical, "提示"
End
End If
End Sub