예제 #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            /*
             * MainFormGiaoVien mainFormGiaoVien = new MainFormGiaoVien("GV001");
             * mainFormGiaoVien.Show();
             */
            mainFrmSinhVien mainFrmSinhVien = new mainFrmSinhVien("SV001");

            mainFrmSinhVien.Show();
        }
예제 #2
0
        private void btnDangNhap_Click(object sender, EventArgs e)
        {
            myDB mydb = new myDB();

            if (rdoSinhVien.Checked)
            {
                SqlCommand command = new SqlCommand("select * from sinhvien where tentaikhoansv = @tk and matkhausv = @mk", mydb.getConnection);
                command.Parameters.Add("@tk", SqlDbType.VarChar).Value = TextBox_Username.Text;
                command.Parameters.Add("@mk", SqlDbType.VarChar).Value = TextBox_Password.Text;
                SqlDataAdapter adapter = new SqlDataAdapter(command);
                DataTable      dt      = new DataTable();
                adapter.Fill(dt);
                if (dt.Rows.Count > 0)
                {
                    mainFrmSinhVien mainSV = new mainFrmSinhVien(dt.Rows[0][0].ToString());
                    Visible = false;
                    mainSV.ShowDialog();
                }
                else
                {
                    MessageBox.Show("Sai Tài khoản hoặc Mật khẩu", "Login Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            else if (rdoGiaoVien.Checked)
            {
                SqlCommand command = new SqlCommand("select * from giaovien where tentaikhoangv = @tk and matkhaugv = @mk", mydb.getConnection);
                command.Parameters.Add("@tk", SqlDbType.VarChar).Value = TextBox_Username.Text;
                command.Parameters.Add("@mk", SqlDbType.VarChar).Value = TextBox_Password.Text;
                SqlDataAdapter adapter = new SqlDataAdapter(command);
                DataTable      dt      = new DataTable();
                adapter.Fill(dt);
                if (dt.Rows.Count > 0)
                {
                    MainFormGiaoVien mainGV = new MainFormGiaoVien(dt.Rows[0][0].ToString());
                    Visible = false;
                    mainGV.ShowDialog();
                }
                else
                {
                    MessageBox.Show("Sai Tài khoản hoặc Mật khẩu", "Login Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            else
            {
                SqlCommand command = new SqlCommand("select * from admin where tentaikhoanad = @tk and matkhauad = @mk", mydb.getConnection);
                command.Parameters.Add("@tk", SqlDbType.VarChar).Value = TextBox_Username.Text;
                command.Parameters.Add("@mk", SqlDbType.VarChar).Value = TextBox_Password.Text;
                SqlDataAdapter adapter = new SqlDataAdapter(command);
                DataTable      dt      = new DataTable();
                adapter.Fill(dt);
                if (dt.Rows.Count > 0)
                {
                    mainFormAdmin mainAD = new mainFormAdmin(dt.Rows[0][0].ToString());
                    Visible = false;
                    mainAD.ShowDialog();
                }
                else
                {
                    MessageBox.Show("Sai Tài khoản hoặc Mật khẩu", "Login Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }