📄 regist.aspx
字号:
<%@ import namespace="system.data"%>
<%@ import namespace="system.data.oledb"%>
<html>
<script language="vb" runat="server">
sub page_load(obj as object,e as eventargs)
row9.visible=false
table2.visible=false
end sub
sub b1_click(obj as object,e as eventargs)
dim str1 as string
dim str2 as string
str1="provider=microsoft.jet.oledb.4.0;data source="&server.mappath("..\bo_store.mdb")
str2="select * from user1 where userid='"&trim(userid.text)&"'"
dim ad as oledbdataadapter
ad=new oledbdataadapter(str2,str1)
dim ds as dataset=new dataset()
ad.fill(ds,"user")
if ds.tables("user").rows.count=0 then
dim r1 as datarow=ds.tables("user").newrow()
r1.item("userid")=trim(userid.text)
r1.item("username")=trim(username.text)
r1.item("psd")=trim(pw.text)
r1.item("userdj")="8"
r1.item("sex")=trim(sex.selecteditem.text)
r1.item("age")=Convert.toint32(age.text)
r1.item("email")=trim(email.text)
r1.item("tele")=trim(tele.text)
r1.item("addr")=trim(addr.text)
ds.tables("user").rows.add(r1)
dim dcb as new oledbcommandbuilder(ad)
ad.update(ds,"user")
table1.visible=false
l21.text=userid.text
l22.text=username.text
l23.text=pw.text
l24.text=sex.selecteditem.text
l25.text=age.text
l26.text=email.text
l27.text=tele.text
l28.text=addr.text
table2.visible=true
else
row9.visible=true
end if
end sub
sub b2_click(obj as object,e as eventargs)
response.redirect("login.aspx")
end sub
</script>
<form id="form1" runat="server">
<asp:table id="table1" runat="server" backcolor="silver" gridlines="both" horizontalalign="center" width="400">
<asp:tablerow id="row0" runat="server" bgcolor="blue">
<asp:tablecell id="cell0" runat="server" Colspan=2 >
<font color="yellow">用户注册</font></asp:tablecell>
</asp:tablerow>
<asp:tablerow id="row1" runat="server" >
<asp:tablecell id="cell11" runat="server" horizontalalign="center" width=80>用户号</asp:tablecell>
<asp:tablecell id="cell12" runat="server"><asp:textbox id="userid" runat="server"/>*</asp:tablecell>
</asp:tablerow>
<asp:tablerow id="row5" runat="server" >
<asp:tablecell id="cell51" runat="server" horizontalalign="center">用户名</asp:tablecell>
<asp:tablecell id="cell52" runat="server"><asp:textbox id="username" runat="server"/></asp:tablecell>
</asp:tablerow>
<asp:tablerow id="row2" runat="server">
<asp:tablecell id="cell21" runat="server" horizontalalign="center">密 码</asp:tablecell>
<asp:tablecell id="cell22" runat="server"><asp:textbox textmode="password" id="pw" runat="server"/>*
</asp:tablecell></asp:tablerow>
<asp:tablerow id="row3" runat="server">
<asp:tablecell id="cell31" runat="server" horizontalalign="center">性 别</asp:tablecell>
<asp:tablecell id="cell32" runat="server">
<asp:radiobuttonlist id="sex" repeatdirection="horizontal" runat="server">
<asp:listitem text="男" selected="true"/>
<asp:listitem text="女"/>
</asp:radiobuttonlist>
</asp:tablecell></asp:tablerow>
<asp:tablerow id="row6" runat="server">
<asp:tablecell id="cell61" runat="server" horizontalalign="center">年 龄</asp:tablecell>
<asp:tablecell id="cell62" runat="server"><asp:textbox id="age" runat="server"/>*
</asp:tablecell></asp:tablerow>
<asp:tablerow id="row4" runat="server">
<asp:tablecell id="cell41" runat="server" horizontalalign="center">e-mail</asp:tablecell>
<asp:tablecell id="cell42" runat="server"><asp:textbox id="email" runat="server" width=260/>
</asp:tablecell></asp:tablerow>
<asp:tablerow id="row7" runat="server">
<asp:tablecell id="cell71" runat="server" horizontalalign="center">电 话</asp:tablecell>
<asp:tablecell id="cell72" runat="server"><asp:textbox id="tele" runat="server"/>
</asp:tablecell></asp:tablerow>
<asp:tablerow id="row8" runat="server">
<asp:tablecell id="cell81" runat="server" horizontalalign="center" width=80>通讯地址</asp:tablecell>
<asp:tablecell id="cell82" runat="server"><asp:textbox id="addr" runat="server"/>
</asp:tablecell></asp:tablerow>
<asp:tablerow id="row10" runat="server">
<asp:tablecell id="cell5" runat="server" Colspan=2 horizontalalign="center">
<asp:button id="b1" runat="server" onclick="b1_click" text="我要注册了！"/></asp:tablecell>
</asp:tablerow>
<asp:tablerow id="row9" runat="server">
<asp:tablecell id="cell91" runat="server" Colspan=2 horizontalalign="center">
<font color="red">警告: 您申请的用户名已被他人占用</font></asp:tablecell>
</asp:tablerow>
</asp:table>
<asp:requiredfieldvalidator id="name_check" runat="server" controltovalidate="userid" Display="none" errormessage="未输入用户号" />
<asp:requiredfieldvalidator id="pw_check" runat="server" controltovalidate="pw" Display="none" errormessage="未输入密码" />
<asp:requiredfieldvalidator id="age_check1" runat="server" controltovalidate="age" Display="none" errormessage="未输入年龄" />
<asp:rangevalidator id="age_check2" minimumvalue="7" maximumvalue="200" runat="server" type="integer" Display="none" controltovalidate="age" errormessage="年龄值非法"/>
<asp:validationsummary id="sum" runat="server" showsummary="false" showmessagebox="true" headertext="下面是验证出错信息" displaymode="bulletlist"/>
<asp:table id="table2" runat="server" backcolor="silver" gridlines="both" horizontalalign="center" width="400">
<asp:tablerow id="row20" runat="server" bgcolor="blue">
<asp:tablecell id="cell20" runat="server" Colspan=2 >
<font color="yellow">用户信息</font></asp:tablecell>
</asp:tablerow>
<asp:tablerow id="row21" runat="server" >
<asp:tablecell id="cell211" runat="server" horizontalalign="center" width=80>用户号</asp:tablecell>
<asp:tablecell id="cell212" runat="server" bgcolor="#ffffff"><asp:label id="l21" runat="server"/></asp:tablecell>
</asp:tablerow>
<asp:tablerow id="row25" runat="server" >
<asp:tablecell id="cell251" runat="server" horizontalalign="center">用户名</asp:tablecell>
<asp:tablecell id="cell252" runat="server" bgcolor="#ffffff"><asp:label id="l22" runat="server"/></asp:tablecell>
</asp:tablerow>
<asp:tablerow id="row22" runat="server">
<asp:tablecell id="cell221" runat="server" horizontalalign="center">密 码</asp:tablecell>
<asp:tablecell id="cell222" runat="server" bgcolor="#ffffff"><asp:label id="l23" runat="server"/></asp:tablecell></asp:tablerow>
<asp:tablerow id="row23" runat="server">
<asp:tablecell id="cell231" runat="server" horizontalalign="center">性 别</asp:tablecell>
<asp:tablecell id="cell232" runat="server" bgcolor="#ffffff"><asp:label id="l24" runat="server"/></asp:tablecell></asp:tablerow>
<asp:tablerow id="row26" runat="server">
<asp:tablecell id="cell261" runat="server" horizontalalign="center">年 龄</asp:tablecell>
<asp:tablecell id="cell262" runat="server" bgcolor="#ffffff"><asp:label id="l25" runat="server"/></asp:tablecell></asp:tablerow>
<asp:tablerow id="row24" runat="server">
<asp:tablecell id="cell241" runat="server" horizontalalign="center">e-mail</asp:tablecell>
<asp:tablecell id="cell242" runat="server" bgcolor="#ffffff"><asp:label id="l26" runat="server"/></asp:tablecell></asp:tablerow>
<asp:tablerow id="row27" runat="server">
<asp:tablecell id="cell271" runat="server" horizontalalign="center">电 话</asp:tablecell>
<asp:tablecell id="cell272" runat="server" bgcolor="#ffffff"><asp:label id="l27" runat="server"/></asp:tablecell></asp:tablerow>
<asp:tablerow id="row28" runat="server">
<asp:tablecell id="cell281" runat="server" horizontalalign="center" width=80>通讯地址</asp:tablecell>
<asp:tablecell id="cell282" runat="server" bgcolor="#ffffff"><asp:label id="l28" runat="server"/></asp:tablecell></asp:tablerow>
<asp:tablerow id="row210" runat="server">
<asp:tablecell id="cell25" runat="server" Colspan=2 horizontalalign="center">
<asp:button id="b2" runat="server" onclick="b2_click" text="我要登录"/></asp:tablecell>
</asp:tablerow>
</asp:table>
</form>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -