这么简单的问题还来问!SHIT!
解决方案 »
- 如何通过webbrowser向网页中的文本框输入字符串?
- 操作数据库 遇到问题,本人初学 百思不得其解,望好心人帮助
- [求助]QB中一个类型不匹配的问题
- VB如何得到光标所在处的句柄!
- 在DBGrid1中,如按“Del”键删除一行记录时,我希望它不被删除,使用以下程序,可是选择 No 时...
- 在VB部件中添加控件时出现如下错误:名称与已存在的模块、工程或对象冲突
- 计划采取comEvReceive 事件触发后再读取input的方式
- 如何取得我当前点击的是DataGrid的哪一个单元,即当前点击位置的(x,y)
- 大家好,能交个朋友吗?QQ:1627660(漫漫长夜无心睡眠)=================
- 帮帮我!!!帮帮我!!!
- 如何设置一个窗体为MDIFORM?
- VC中的CString类型在VB中应该用什么代替??!!!
想dreammaker这类人简直....
insert into 表名 values('" & txtuser & "','" & txtpassword & "')用个combox,
循环 do until rs.eof
combox.additem txtuser/txtpassword loop很easy的问题,也不要怪别人说你,学到东西最重要
Dim cnnPass As New ADODB.Connection
Dim rstPass As New ADODB.Recordset
Dim strSQL As String
Dim LoginSucceeded As Boolean
Private Sub cmdCancel_Click()
LoginSucceeded = False
Unload Me
End Sub
_________________________________________
Private Sub cmdOK_Click()
LSize = Len(CombUserName.Text)
If LSize 0 Then
User = Left$(CombUserName.Text, LSize)
Else
User = vbNullString
End If
If User = "管理员" Then
Pass = rstPass!Password
If txtPassword.Text = Pass Then
LoginSucceeded = True
Else
MsgBox "无效的密码,请重试!", vbExclamation + vbOKOnly, "登录"
txtPassword.SetFocus
SendKeys "{Home}+{End}"
End If
ElseIf User = "普通用户" Then
User = "普通用户"
LoginSucceeded = True
'在此加入一些限制代码
Unload Me
Else
MsgBox "非法用户!!!", , "登录"
CombUserName.SetFocus
txtPassword.SelLength = Len(txtPassword.Text)
SendKeys "{Home}+{End}"
End If
End Sub
___________________________________________________
Private Sub Form_Load()
DatName = App.Path & "\DBNAME.dll"
cnnPass.Provider = "microsoft.jet.oledb.3.51"
cnnPass.Open DatName, "admin"
strSQL = "select * from regpass "
rstPass.CursorLocation = adUseServer
rstPass.Open strSQL, cnnPass, adOpenKeyset, adLockReadOnly, adCmdText
With CombUserName
Set .DataSource = rstPass
.DataField = "UserName"
Set .RowSource = rstPass
.ListField = "UserName"
.BoundColumn = "UserName"
End With
CombUserName.Text = "管理员"
End SubPrivate Sub Form_Unload(Cancel As Integer)
If rstPass.State = adStateOpen Then
rstPass.Close
Set rstPass = Nothing
End If
If cnnPass.State = adStateOpen Then
cnnPass.Close
Set cnnPass = Nothing
End IfEnd Sub