Crdown's学习笔记

ASP.NET,Report...

博客园 首页 新随笔 联系 订阅 管理

前台代码:

 

代码
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="reg.aspx.cs" Inherits="reg" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>注册页面</title>
<style type="text/css">
.style1
{
color: #FF0000;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<br />
<br />
请输入您的用户名:
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<span class="style1">请用英文用户名</span><asp:RequiredFieldValidator
ID
="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox1"
Display
="Dynamic" ErrorMessage="请输入用户名">*</asp:RequiredFieldValidator>
<br />
<br />
请输入您的密
&nbsp;&nbsp;&nbsp; 码:<asp:TextBox ID="TextBox2" runat="server"
TextMode
="Password"></asp:TextBox>
<span class="style1">请输入至少6位</span><asp:RequiredFieldValidator
ID
="RequiredFieldValidator2" runat="server" ControlToValidate="TextBox2"
Display
="Dynamic" ErrorMessage="请输入密码">*</asp:RequiredFieldValidator>
<br />
<br />
请再次输入密
&nbsp;&nbsp;&nbsp; 码:<asp:TextBox ID="TextBox3" runat="server"
TextMode
="Password"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
ControlToValidate
="TextBox3" Display="Dynamic" ErrorMessage="请再次输入密码">*</asp:RequiredFieldValidator>
<asp:CompareValidator ID="CompareValidator1" runat="server"
ControlToCompare
="TextBox3" ControlToValidate="TextBox2" Display="Dynamic"
ErrorMessage
="输入不一致,请重新输入">*</asp:CompareValidator>
<br />
<br />
请选择目标工作岗位:
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>报到处</asp:ListItem>
<asp:ListItem>财务处</asp:ListItem>
</asp:DropDownList>

</div>
<p>
您的联系手机号码是:
<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
<span class="style1">请输入手机号便于联系</span><asp:RequiredFieldValidator
ID
="RequiredFieldValidator4" runat="server" ControlToValidate="TextBox4"
Display
="Dynamic" ErrorMessage="请输入您的手机号码便于联系">*</asp:RequiredFieldValidator>
</p>
<asp:ValidationSummary ID="ValidationSummary1" runat="server" />
<p>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="提交注册" />
</p>
<asp:Label ID="Label1" runat="server" ForeColor="Red"></asp:Label>
</form>
</body>
</html>

 

 

 

后台代码:

 

 

代码
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.OleDb;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class reg : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
string user = TextBox1.Text.Trim().ToString();
string pass = TextBox2.Text.Trim().ToString();
string work = DropDownList1.SelectedValue.ToString();
string tel = TextBox4.Text.Trim().ToString();
string md5pass = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(pass, "MD5");
OleDbCommand cha
= new OleDbCommand("select count(*) as icount from usersheet where LoginName = '" + user + "'", Conn.mdbconn());
OleDbDataReader i
= cha.ExecuteReader();
i.Read();
string count = i["icount"].ToString();
i.Close();
Conn.mdbconn().Close();
if (count != "0")
{
Label1.Text
= "对不起您输入的用户名已经被占用,请重新输入其他用户名!";
}
else
{
OleDbCommand zhuce
= new OleDbCommand("insert into usersheet (loginname,userpass,works,tel1) values ('" + user + "','" + md5pass + "','" + work + "','" + tel + "')", Conn.mdbconn());
int myupdate = zhuce.ExecuteNonQuery();
Conn.mdbconn().Close();
if (myupdate > 0)
{
Page.ClientScript.RegisterStartupScript(Page.GetType(),
"message", "<script language='javascript'>alert('已经注册成功,请等待审核!');window.location='login.aspx';</script>");
}
}
}
}

 

新手作品 , 仅供参考吧。acc+asp.net

posted on 2010-03-22 10:47  Crdown  阅读(856)  评论(4编辑  收藏  举报