userregister.aspx.cs
来自「用ASP.NET(C#)、SQL Server2000数据库开发在线考试系统源代」· CS 代码 · 共 117 行
CS
117 行
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace ExamineSystem
{
/// <summary>
/// Summary description for UserRegister.
/// </summary>
public class UserRegister : System.Web.UI.Page
{
protected System.Web.UI.HtmlControls.HtmlGenericControl title;
protected System.Web.UI.WebControls.TextBox UserName;
protected System.Web.UI.WebControls.RequiredFieldValidator UName;
protected System.Web.UI.WebControls.TextBox Password;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
protected System.Web.UI.WebControls.TextBox PasswordStr;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
protected System.Web.UI.WebControls.TextBox Email;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
protected System.Web.UI.WebControls.Button AddUserBtn;
protected System.Web.UI.WebControls.Button CancelBtn;
protected System.Web.UI.WebControls.Label EqualLoginName;
private void Page_Load(object sender, System.EventArgs e)
{
//
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.AddUserBtn.Click += new System.EventHandler(this.AddUserBtn_Click);
this.CancelBtn.Click += new System.EventHandler(this.CancelBtn_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void AddUserBtn_Click(object sender, System.EventArgs e)
{
UserDB user = new UserDB();
String userId = "";
int nUserID = 0;
SqlConnection myConnection = new SqlConnection(SQLHelper.DBCONNECTIONSTRING);
String cmdTxt = "Select * from Users Where UserName ='"+ UserName.Text.Trim() +"'";
SqlCommand myCommand = new SqlCommand(cmdTxt,myConnection);
myConnection.Open();
SqlDataReader recu = myCommand.ExecuteReader();
while(recu.Read())
{
userId = recu["UserID"].ToString();
if((userId != null)&&(userId != ""))
{
Response.Write("<script>alert(\"该用户已存在!\")</script>");
UserName.Text = "";
Password.Text = PasswordStr.Text = "";
}
else if(Password.Text == PasswordStr.Text)
{
try
{
nUserID = user.AddUser(UserName.Text.Trim(),UserDB.Encrypt(Password.Text.Trim()),
CleanString.InputText(Email.Text.Trim(),Email.Text.Length));
EqualLoginName.Text = "注册成功,请从程序首页登录!";
EqualLoginName.Visible = true;
}
catch(Exception ex)
{
///错误处理
EqualLoginName.Text = "注册失败,失败的原因如下:" + ex.Message;
EqualLoginName.Visible = true;
}
}
else
{
Response.Write("<script>alert(\"你两次输入的密码不相等,请重新输入!\")</script>");
}
}recu.Close();myConnection.Close();
}
private void CancelBtn_Click(object sender, System.EventArgs e)
{
UserName.Text = "";
Password.Text = PasswordStr.Text = "";
Email.Text = "";
}
}
}
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?