|
|
|
ASP.NET Register C# ช่วยดูโค๊ดให้หน่อยค่ะ เก็บข้อมูลสมาชิก โดยใช้ 2 ฐานข้อมูล |
|
|
|
|
|
|
|
จากบทความนี้
ต้องการเก็บข้อมูลสมาชิกในลงใน 2 ฐานข้อมูล
จะต้องแก้ตรงไหนเพิ่มคะ
Code (C#)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Text;
namespace AspNetMember
{
public partial class frmRegister : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
this.pnlRegister.Visible = true;
this.pnlFinish.Visible = false;
}
protected void btnRegister_Click(object sender, EventArgs e)
{
SqlConnection objConn = null;
string strConnString = null;
StringBuilder strSQL = default(StringBuilder);
SqlCommand objCmd = null;
int intCount = 0;
//*** Open Connection ***'
strConnString = "Server=localhost;UID=sa;PASSWORD=123456;database=mydatabase;Max Pool Size=400;Connect Timeout=600;";
objConn = new SqlConnection();
objConn.ConnectionString = strConnString;
objConn.Open();
//*** Check Username exists ***'
strSQL = new StringBuilder();
strSQL.Append(" SELECT COUNT(*) FROM member ");
strSQL.Append(" WHERE Username = @sUsername ");
objCmd = new SqlCommand(strSQL.ToString(), objConn);
objCmd.Parameters.Add("@sUsername", SqlDbType.VarChar).Value = this.txtUsername.Text;
intCount = (int)objCmd.ExecuteScalar();
if (intCount >= 1)
{
this.lblStatus.ForeColor = System.Drawing.Color.Red;
this.lblStatus.Text = "Username already exists!!";
return;
}
//*** Check Email exists ***'
strSQL = new StringBuilder();
strSQL.Append(" SELECT COUNT(*) FROM member ");
strSQL.Append(" WHERE Email = @sEmail ");
objCmd = new SqlCommand(strSQL.ToString(), objConn);
objCmd.Parameters.Add("@sEmail", SqlDbType.VarChar).Value = this.txtEmail.Text;
intCount = (int)objCmd.ExecuteScalar();
if (intCount >= 1)
{
this.lblStatus.ForeColor = System.Drawing.Color.Red;
this.lblStatus.Text = "Email already exists!!";
return;
}
//*** Insert New Member ***'
strSQL = new StringBuilder();
strSQL.Append(" INSERT INTO member ");
strSQL.Append(" (Username,Password,Name,Email,Country) ");
strSQL.Append(" VALUES ");
strSQL.Append(" (@sUsername,@sPassword,@sName,@sEmail,@sCountry) ");
objCmd = new SqlCommand(strSQL.ToString(), objConn);
objCmd.Parameters.Add("@sUsername", SqlDbType.VarChar).Value = this.txtUsername.Text;
objCmd.Parameters.Add("@sPassword", SqlDbType.VarChar).Value = this.txtPassword.Text;
objCmd.Parameters.Add("@sName", SqlDbType.VarChar).Value = this.txtName.Text;
objCmd.Parameters.Add("@sEmail", SqlDbType.VarChar).Value = this.txtEmail.Text;
objCmd.Parameters.Add("@sCountry", SqlDbType.VarChar).Value = this.txtCountry.Text;
objCmd.ExecuteNonQuery();
objConn.Close();
objConn = null;
this.pnlRegister.Visible = false;
this.pnlFinish.Visible = true;
}
}
}
Tag : Ms SQL Server 2008, Web (ASP.NET), C#
|
|
|
|
|
|
Date :
2013-11-19 03:52:16 |
By :
Kaew |
View :
748 |
Reply :
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ขอถามเพิ่มค่ะ
แล้วจะเข้ารหัส md5 ยังไงคะ
มือใหม่จริงๆค่ะ
|
|
|
|
|
Date :
2013-11-19 04:09:52 |
By :
Kaew |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ทำไมจะต้องใช้ 2 ฐานข้อมูลครับ ส่วน MD5 ค้นหาในกระทู้/บทความได้ครับ
|
|
|
|
|
Date :
2013-11-19 06:15:19 |
By :
mr.win |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 05
|