private void QuanLyTaiKhoan_Load(object sender, EventArgs e)
{
Connect_DB.openConn();
string query = "select giaovien.magiaovien , hoten, mataikhoan, tentaikhoan,matkhau from taikhoan inner join giaovien on taikhoan.magiaovien = giaovien.magiaovien; ";
SqlCommand cmd = new SqlCommand(query, Connect_DB.connect());
cmd.CommandType = CommandType.Text;
SqlDataAdapter adt = new SqlDataAdapter(cmd);
DataTable dtb = new DataTable();
adt.Fill(dtb);
dgv_taikhoan.DataSource = dtb;
// Select mã giáo viên cho combobox
string queryMGV = "Select * from giaovien";
SqlCommand cmd2 = new SqlCommand(queryMGV, Connect_DB.conn);
SqlDataAdapter da = new SqlDataAdapter(cmd2);
DataSet ds = new DataSet();
da.Fill(ds);
cb_maGV.DataSource = ds.Tables[0];
cb_maGV.ValueMember = "magiaovien";
cb_maGV.DisplayMember = "magiaovien";
cb_maGV.Enabled = true;
Connect_DB.closeConn();
}
private void button1_Click(object sender, EventArgs e)
{
String tendn = txtTenDN.Text;
String mk = txtMK.Text;
SqlConnection conn = Connect_DB.connect();
conn.Open();
string queryString = "SELECT * FROM taikhoan where tentaikhoan = @tentaikhoan and matkhau = @matkhau;";
SqlCommand command = new SqlCommand(queryString, conn);
command.Parameters.Add("@tentaikhoan", SqlDbType.NVarChar, 50).Value = tendn;
command.Parameters.Add("@matkhau", SqlDbType.NVarChar, 255).Value = Hash(mk);
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
reader.Close();
conn.Close();
this.Hide();
TrangChu tc = new TrangChu();
tc.Show();
}
else
{
reader.Close();
conn.Close();
MessageBox.Show("Tên đăng nhập hoặc mật khẩu k đúng");
}
}
}
private void tab_QLHS_Click(object sender, EventArgs e)
{
Connect_DB.openConn();
SqlCommand cmd = new SqlCommand("Select * from hocsinh", Connect_DB.connect());
cmd.CommandType = CommandType.Text;
SqlDataAdapter adt = new SqlDataAdapter(cmd);
DataTable dtb = new DataTable();
DataTable dtb2 = new DataTable();
adt.Fill(dtb);
adt.Fill(dtb2);
dgv_Capnhat.DataSource = dtb;
dgv_XoaHS.DataSource = dtb2;
Connect_DB.closeConn();
}
