Private Sub Command1_Click()
Dim i%
sqls = "select * from data_users"
rs.CursorLocation = adUseClient
rs.Open sqls, conn, adOpenKeyset, adLockPessimistic
x = rs.RecordCount
rs.MoveFirst
For i = 1 To x
If Text1 = rs.Fields("用户名").Value Then
MsgBox "该用户名已被注册", vbOKOnly + 32, "出错"
GoTo a
End If
rs.MoveNext
Next i rs.MoveFirst
For i = 1 To x
If Text1 = "" Or Text2 = "" Then
MsgBox "请输入有交的数据", vbOKOnly + 32, "出错"
End If
If Text2 <> Text3 Then
MsgBox "密码不一致", vbOKOnly + 32, "出错"
End If
If Text2 = Text3 And Text1 <> "" And Text2 <> "" And Text1 <> rs.Fields("用户名").Value Then
conn.Execute "Insert into data_users(用户名,密码) values('" & Text1.Text & "','" & Text2.Text & "')"
MsgBox "恭喜您,注册成功,请您保管好帐号跟密码", vbOKOnly + 64, "注册成功"
Command2.Visible = False
End If
a:
End Sub
Dim i%
sqls = "select * from data_users"
rs.CursorLocation = adUseClient
rs.Open sqls, conn, adOpenKeyset, adLockPessimistic
x = rs.RecordCount
rs.MoveFirst
For i = 1 To x
If Text1 = rs.Fields("用户名").Value Then
MsgBox "该用户名已被注册", vbOKOnly + 32, "出错"
GoTo a
End If
rs.MoveNext
Next i rs.MoveFirst
For i = 1 To x
If Text1 = "" Or Text2 = "" Then
MsgBox "请输入有交的数据", vbOKOnly + 32, "出错"
End If
If Text2 <> Text3 Then
MsgBox "密码不一致", vbOKOnly + 32, "出错"
End If
If Text2 = Text3 And Text1 <> "" And Text2 <> "" And Text1 <> rs.Fields("用户名").Value Then
conn.Execute "Insert into data_users(用户名,密码) values('" & Text1.Text & "','" & Text2.Text & "')"
MsgBox "恭喜您,注册成功,请您保管好帐号跟密码", vbOKOnly + 64, "注册成功"
Command2.Visible = False
End If
a:
End Sub
解决方案 »
- vb 中用GetIpAddrTable函数获取IP地址的问题
- 删除整条记录
- 怎么删除指定文件夹下的文件!?
- vb中对URL进行编码的函数的是什么啊?
- 用winsock同时传送几个文件的时候,为什么有时传了一个文件或者两个文件后就会停止??有什么解决方法吗??
- 急,请各位进来看看
- 我在set datagrid1.datasource=rs 时出错(在线求助)
- 代码不能运行
- 如何判断treeview下的节点是否有子节点阿?
- 我想用做一个共享软件,总是选不中题目,有人知道吗?说来听听!
- 我是菜鸟中的菜鸟啊!希望大家多多帮忙啊!感激不尽啊!在线等待~
- DataReport+DataEnvironment设计的报表的打印问题
还是问这个代码是不是注册新用户的?
还是问??