1@ Import Namespace="System.Data"
1@ Import Namespace="System.Data.SQL"
1<html>
2<head><title>ASP+注册</title>
3<link href="main.css" rel="stylesheet" type="text/css"/>
4<script language="C#" runat="Server">
5void btnSubmit_Click(Object Src,EventArgs E)
6{
7if(Page.IsValid)
8{
9String strSQL;
10strSQL="INSERT INTO tblUserInfo VALUES(@UserName,@PassWord,@Email)";
11
12SQLConnection cnn=new SQLConnection("Server=niu;UID=sa;PWD=;DataBase=aspx");
13SQLCommand cmm=new SQLCommand(strSQL,cnn);
14
15cmm.Parameters.Add(new SQLParameter("@UserName",SQLDataType.VarChar,20));
16cmm.Parameters["@UserName"].Value=txtName.Text;
17
18cmm.Parameters.Add(new SQLParameter("@PassWord",SQLDataType.VarChar,20));
19cmm.Parameters["@PassWord"].Value=txtName.Text;
20
21cmm.Parameters.Add(new SQLParameter("@Email",SQLDataType.VarChar,60));
22cmm.Parameters["@Email"].Value=txtName.Text;
23
24cmm.ActiveConnection.Open();
25try
26{
27cmm.Execute();
28cmm.ActiveConnection.Close();
29Page.Navigate("result.aspx");
30}
31catch
32{
33lblMsg.Style["color"]="red";
34lblMsg.Text="插入数据出错";
35}
36}
37
38}
39</script>
40</head>
41<body>
42<h2 align="center">ASP+注册系统</h2>
43<asp:label id="lblMsg" runat="Server/">
44<form runat="Server">
45<table align="center" bgcolor="#eeeeee" cellpadding="10">
46<tr>
47<td>姓名：</td>
48<td>
49<asp:textbox class="mytext" id="txtName" maxlength="20" runat="Server/">
50</asp:textbox></td>
51<td>
52<asp:requiredfieldvalidator controltovalidate="txtName" display="Dynamic" errormessage="*" id="rfvName" initalvalue="" runat="Server">
53</asp:requiredfieldvalidator>
54</td>
55</tr>
56<tr>
57<td>密码：</td>
58<td>
59<asp:textbox class="mytext" id="txtPassWord" maxlength="20" runat="Server/" textmode="PassWord">
60</asp:textbox></td>
61<td>
62<asp:requiredfieldvalidator controltovalidate="txtPassWord" display="Dynamic" errormessage="*" id="rfvPassWord" initialvalue="" runat="Server">
63</asp:requiredfieldvalidator>
64</td>
65</tr>
66<tr>
67<td>确认密码：</td>
68<td>
69<asp:textbox class="mytext" id="txtRePassWord" maxlength="20" runat="Server/" textmode="PassWord">
70</asp:textbox></td>
71<td>
72<asp:requiredfieldvalidator controltovalidate="txtRePassWord" display="Dynamic" errormessage="*" id="rfvRePassWord" initialvalue="" runat="Server">
73</asp:requiredfieldvalidator>
74<asp:comparevalidator controltocompare="txtPassWord" controltovalidate="txtRePassWord" display="Dynamic" errormessage="密码确认错，请注意字母大小写！" id="cvRePassWord" runat="Server">
75</asp:comparevalidator>
76</td>
77</tr>
78<tr>
79<td>电子邮件：</td>
80<td>
81<asp:textbox class="mytext" id="txtEmail" maxlength="60" runat="Server/">
82</asp:textbox></td>
83<td>
84<asp:requiredfieldvalidator controltovalidate="txtEmail" display="Dynamic" errormessage="*" id="rvfEmail" initialvalue="" runat="Server">
85</asp:requiredfieldvalidator>
86<asp:regularexpressionvalidator controltovalidate="txtEmail" display="Dynamic" errormessage="无效电子邮件地址！" id="revEmail" runat="Server" validationexpression="^[\w-]+@[\w-]+\\.(com|net|org|edu|mil)$">
87</asp:regularexpressionvalidator>
88</td>
89</tr>
90<tr>
91<td align="center" colspan="3">
92<asp:button class="mybtn" id="btnSubmit" onclick="btnSubmit_Click" runat="Server/" text="提交">
93</asp:button></td>
94</tr>
95</table>
96</form>
97</asp:label></body>
98</html>