IDC资讯中心
<%@ page language="c#" %>
<%@ import namespace="system.data" %>
<%@ import namespace="system.data.sql" %>
<html>
<head><title>asp+注册</title>
<link rel="stylesheet" type="text/css" href="main.css">
<script language="c#" runat=server>
void btnsubmit_click(object src,eventargs e)
{
if(page.isvalid)
{
string strsql;
strsql="insert into tbluserinfo values(@username,@password,@email)";
sqlconnection cnn=new sqlconnection("server=niu;uid=sa;pwd=;database=aspx");
sqlcommand cmm=new sqlcommand(strsql,cnn);
cmm.parameters.add(new sqlparameter("@username",sqldatatype.varchar,20));
cmm.parameters["@username"].value=txtname.text;
cmm.parameters.add(new sqlparameter("@password",sqldatatype.varchar,20));
cmm.parameters["@password"].value=txtname.text;
cmm.parameters.add(new sqlparameter("@email",sqldatatype.varchar,60));
cmm.parameters["@email"].value=txtname.text;
cmm.activeconnection.open();
try
{
cmm.execute();
cmm.activeconnection.close();
page.navigate("result.aspx");
}
catch
{
lblmsg.style["color"]="red";
lblmsg.text="插入数据出错";
}
}
}
</script>
</head>
<body>
<h2 align="center">asp+注册系统</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="^[\w-]+@[\w-]+\.(com|net|org|edu|mil)$"
runat=server>
</asp:regularexpressionvalidator>
</td>
</tr>
<tr>
<td colspan="3" align="center">
<asp:button id="btnsubmit" onclick="btnsubmit_click" text="提交" class="mybtn" runat=server/>
</td>
</tr>
</table>
</form>
</body>
</html>
from chinaasp.com
