제목 : 7.2.1. 회원가입 페이지 : Register.aspx.cs
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;//
using System.Configuration;//
namespace Home.Member
{
public class Register : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Button btnCommand;
protected System.Web.UI.WebControls.TextBox txtUserID;
protected System.Web.UI.WebControls.TextBox txtUserName;
protected System.Web.UI.WebControls.TextBox txtPassword;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
protected System.Web.UI.WebControls.TextBox txtPasswordConfirm;
protected System.Web.UI.WebControls.CompareValidator CompareValidator1;
protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
protected System.Web.UI.WebControls.ValidationSummary ValidationSummary1;
protected System.Web.UI.WebControls.TextBox txtEmail;
private void Page_Load(object sender, System.EventArgs e)
{
}
#region Web Form 디자이너에서 생성한 코드
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 이 호출은 ASP.NET Web Form 디자이너에 필요합니다.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 디자이너 지원에 필요한 메서드입니다.
/// 이 메서드의 내용을 코드 편집기로 수정하지 마십시오.
/// </summary>
private void InitializeComponent()
{
this.btnCommand.Click += new System.EventHandler(this.btnCommand_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
// 회원 가입
private void btnCommand_Click(object sender, System.EventArgs e)
{
SqlConnection objCon = new SqlConnection(
ConfigurationSettings.AppSettings["ConnectionString"]);
objCon.Open();
SqlCommand objCmd = new SqlCommand();
objCmd.Connection = objCon;
objCmd.CommandText =
"Select Count(*) From Users Where UserID = '"
+ this.txtUserID.Text + "'";
objCmd.CommandType = CommandType.Text;
int intCount = (int)objCmd.ExecuteScalar();
if(intCount > 0)
{
string strMsg =
"<script>alert(\"이미 있는 사용자입니다.\");</script>";
this.RegisterClientScriptBlock("no", strMsg);
}
else
{
objCmd.CommandText = "procInsertUsers";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add(
new SqlParameter("@UserID", this.txtUserID.Text));
objCmd.Parameters.Add(
new SqlParameter("@UserName", this.txtUserName.Text));
objCmd.Parameters.Add(
new SqlParameter("@Password", this.txtPassword.Text));
objCmd.Parameters.Add(
new SqlParameter("@Email", this.txtEmail.Text));
objCmd.ExecuteNonQuery();
objCon.Close();
string strMsg =
"<script>alert(\"회원가입을 축하드립니다.\");</script>";
this.RegisterClientScriptBlock("ok", strMsg);
// 회원 가입과 동시에 로그인 처리...
Response.Redirect("/Home/Default.aspx");//이동
}
}
}
}