zhuce2.aspx
来自「《精通ASP.NET网络编程》附带实例」· ASPX 代码 · 共 137 行
ASPX
137 行
<%@Page Language="C#"%>
<!--引入必要的Namespace -->
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<html>
<head>
<title>ASP.NET简易注册系统</title>
<Script Language="C#" runat=Server>
void btnSubmit_Click(Object Src,EventArgs E)
{
if(Page.IsValid)
//当各项值都通过验证时
{
//与Access数据库进行链接
String strConn="Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source="+Server.MapPath("sample.mdb");
OleDbConnection myConn = new OleDbConnection(strConn);
//打开链接
myConn.Open();
String StrSQL;
StrSQL="Select * From zhuce Where username='"+txtName.Text+"'";
OleDbCommand myCommand= new OleDbCommand(StrSQL, myConn);
//用用reader对象来查询用户名是否已经存在
OleDbDataReader reader = myCommand.ExecuteReader();
if(reader.Read())
{//若存在
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>";
}
//关闭链接
myConn.Close();
}
}
</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 + -
显示快捷键?