zhuce1.aspx
来自「《精通ASP.NET网络编程》附带实例」· ASPX 代码 · 共 135 行
ASPX
135 行
<%@Page Language="VB"%>
<!--引入必要的Namespace -->
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<html>
<head>
<title>ASP.NET简易注册系统</title>
<Script Language="VB" runat=Server>
Sub btnSubmit_Click(Src As Object,E As EventArgs)
If(Page.IsValid) Then
'当各项值都通过验证时
'与Access数据库进行链接
Dim strConn As String="Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source="+Server.MapPath("sample.mdb")
Dim myConn As OleDbConnection= new OleDbConnection(strConn)
'打开链接
myConn.Open()
Dim StrSQL As String
StrSQL="Select * From zhuce Where username='"+txtName.Text+"'"
Dim myCommand As OleDbCommand= new OleDbCommand(StrSQL, myConn)
'用reader对象来查询用户名是否已经存在
Dim reader As OleDbDataReader
reader = myCommand.ExecuteReader()
If reader.Read() Then
'若存在
Message.InnerHtml = "<p align=center><B>该用户已经存在!</B>"
reader.Close()
Else
'不存在,则将该用户信息增加到数据库
reader.Close()
StrSQL="INSERT INTO zhuce VALUES('"+txtName.Text+"','"+txtPassWord.Text+"','"+txtEmail.Text+"')"
myCommand = new OleDbCommand(StrSQL, myConn)
'执行插入语句
myCommand.ExecuteNonQuery()
Message.InnerHtml = "<p align=center><B>注册成功!</B>"
End If
'关闭链接
myConn.Close()
End If
End Sub
</Script>
</head>
<body>
<h2 align="center">ASP.NET简易注册系统</h2>
<asp:Label ID="lblMsg" runat=Server/>
<form runat=Server>
<table bgcolor="#eeeeee" cellpadding="10" align="center">
<tr>
<td>用户名:</td>
<td>
<asp:TextBox ID="txtName" MaxLength="20" Class="mytext" runat=Server/>
</td>
<td>
<!--判断用户名是否为空-->
<asp:RequiredFieldValidator ID="rfvName"
ControlToValidate="txtName"
Display="Dynamic"
InitalValue=""
ErrorMessage="*"
runat=Server>
</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>密码:</td>
<td>
<asp:TextBox ID="txtPassWord" TextMode="PassWord" MaxLength="20"
Class="mytext" runat=Server/>
</td>
<td>
<asp:RequiredFieldValidator ID="rfvPassWord"
ControlToValidate="txtPassWord"
Display="Dynamic"
InitialValue=""
ErrorMessage="*"
runat=Server>
</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>确认密码:</td>
<td>
<asp:TextBox ID="txtRePassWord" TextMode="PassWord"
MaxLength="20" Class="mytext" runat=Server/>
</td>
<td>
<asp:RequiredFieldValidator ID="rfvRePassWord"
ControlToValidate="txtRePassWord"
Display="Dynamic"
InitialValue=""
ErrorMessage="*"
runat=Server>
</asp:RequiredFieldValidator>
<!--判断两次输入密码是否相同-->
<asp:CompareValidator ID="cvRePassWord"
ControlToValidate="txtRePassWord" ControlToCompare="txtPassWord"
Display="Dynamic"
ErrorMessage="密码确认错,请注意字母大小写!"
runat=Server>
</asp:CompareValidator>
</td>
</tr>
<tr>
<td>电子邮件:</td>
<td>
<asp:TextBox ID="txtEmail" MaxLength="60" Class="mytext" runat=Server/>
</td>
<td>
<asp:RequiredFieldValidator ID="rvfEmail"
ControlToValidate="txtEmail"
InitialValue=""
Display="Dynamic"
ErrorMessage="*"
runat=Server>
</asp:RequiredFieldValidator>
<!--对用户的电子邮件地址进行验证-->
<asp:RegularExpressionValidator ID="revEmail"
ControlToValidate="txtEmail"
Display="Dynamic"
ErrorMessage="无效电子邮件地址!"
ValidationExpression=".{1,}@.{3,}"
runat=Server>
</asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td colspan="3" align="center">
<asp:Button ID="btnSubmit" OnClick="btnSubmit_Click" Text="提交" runat=Server/>
</td>
</tr>
</table>
</form>
<div id=Message runat=server></div>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?