예제 #1
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            KetNoiCSDL ketNoi = new KetNoiCSDL();
            string     sql    = @"select count(*) from admin where Username = @user and Password = @pass";

            ketNoi.MoKetNoi();
            SqlCommand cmd = new SqlCommand(sql, ketNoi.LayKetNoi);

            cmd.Parameters.AddWithValue("@user", txtUsername.Text);
            cmd.Parameters.AddWithValue("@pass", txtPassword.Text);
            int result = (int)cmd.ExecuteScalar();

            if (result >= 1)
            {
                Session["login"] = txtUsername.Text;
                Response.Redirect("index.aspx");
            }
            else
            {
                lblThongBao.Text = "Sai mật khẩu hoặc tài khoản!!!";
            }
        }