using System.Data.OleDb;

public partial class AddNewUser : System.Web.UI.Page

{

<tab>protected void Page_Load(object sender, EventArgs e)

<tab>{

<tab><tab>lblTB.Text = "";

<tab><tab>lblLoiTenDangKy.Visible = false;

<tab><tab>lblLoiMatKhau.Visible = false;

<tab><tab>lblLoiMatKhauKhongTrungKhop.Visible = false;

<tab><tab>lblTB.Visible = false;

<tab>}

<tab>protected void btnBoQua_Click(object sender, EventArgs e)

<tab>{

<tab><tab>Response.Redirect("~/default.aspx");

<tab>}

<tab>protected void btnDangKy_Click(object sender, EventArgs e)

<tab>{

<tab><tab>bool loi = false;

<tab><tab>if (txtTenDangKy.Text == "")

<tab><tab>{

<tab><tab><tab>lblTB.Text = lblTB.Text + "<br>Chưa nhập tên đăng ký";

<tab><tab><tab>lblLoiTenDangKy.Visible = true;

<tab><tab><tab>lblTB.Visible = true;

<tab><tab><tab>loi = true;

<tab><tab>}

<tab><tab>if (txtMatKhau.Text == "" || txtGoLaiMatKhau.Text == "")

<tab><tab>{

<tab><tab><tab>lblTB.Text = lblTB.Text + "<br>Chưa nhập mật khẩu";

<tab><tab><tab>lblLoiMatKhau.Visible = true;

<tab><tab><tab>lblTB.Visible = true;

<tab><tab><tab>loi = true;

<tab><tab>}

<tab><tab>if (txtMatKhau.Text != txtGoLaiMatKhau.Text)

<tab><tab>{

<tab><tab><tab>lblTB.Text = lblTB.Text + "<br>Hai mat khau chưa giống nhau";

<tab><tab><tab>lblLoiMatKhauKhongTrungKhop.Visible = true;

<tab><tab><tab>lblTB.Visible = true;

<tab><tab><tab>loi = true;

<tab><tab>}

<tab><tab>if (loi == true)

<tab><tab>{

<tab><tab><tab>return;

<tab><tab>}

 // tien hanh them nguoi dung

<tab><tab>OleDbConnection Cn = new OleDbConnection();

<tab><tab>Cn.ConnectionString="Provider=Microsoft.Jet.OleDb.4.0; Data/~App_Data/DuLieu.mdb");

<tab><tab>Cn.Open();

<tab><tab>OleDbCommand Cmd = new OleDbCommand();

<tab><tab>Cmd.Connection = Cn;

<tab><tab>Cmd.CommandText = "Insert Into NguoiDung(Ten,MatKhau) Values(?,?)"; 

<tab><tab>Cmd.Parameters.Add(new OleDbParameter("ten", txtTenDangKy.Text));

<tab><tab>Cmd.Parameters.Add(new OleDbParameter("matkhau", txtMatKhau.Text));

<tab><tab>int d = Cmd.ExecuteNonQuery();

<tab><tab>Cn.Close();

<tab><tab>if (d > 0)

<tab><tab>{

<tab><tab><tab>lblTB.Text = "Đã đăng ký thành công";

<tab><tab><tab>lblTB.Visible = true;

<tab><tab><tab>btnDangKy.Enabled = false;

<tab><tab>}

<tab><tab>else

<tab><tab>{

<tab><tab><tab>lblTB.Text = "Chưa đăng ký được. Đề nghị thử lại.";

<tab<tab>><tab>lblTB.Visible = true;

<tab><tab>}

<tab>}

}