private void btnSearch_HocSinh_Click(object sender, EventArgs e) { if (cbOption.Text.Equals("")) { MessageBox.Show("Chọn tiêu chí cần sắp xếp", "ERROR!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (cbOption.Text.Equals("Mã học sinh")) { DATA.SqlConn sql = new DATA.SqlConn(); string tb = "HocSinh"; string key = "mahocsinh"; dgvHocSinh.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_HocSinh.Text.Trim() + "%'"); LockControl(); } if (cbOption.Text.Equals("Tên học sinh")) { DATA.SqlConn sql = new DATA.SqlConn(); string tb = "HocSinh"; string key = "hoten"; dgvHocSinh.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_HocSinh.Text.Trim() + "%'"); LockControl(); } if (cbOption.Text.Equals("Mã lớp")) { DATA.SqlConn sql = new DATA.SqlConn(); string tb = "HocSinh"; string key = "malop"; dgvHocSinh.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_HocSinh.Text.Trim() + "%'"); LockControl(); } }
private void btnSearch_GiangDay_Click(object sender, EventArgs e) { if (cbOption_GiangDay.Text.Equals("")) { MessageBox.Show("Chọn tiêu chí cần sắp xếp", "ERROR!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (cbOption_GiangDay.Text.Equals("Mã giáo viên")) { DATA.SqlConn sql = new DATA.SqlConn(); string tb = "GiangDay"; string key = "magiaovien"; dgvGiangDay.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_GiangDay.Text.Trim() + "%'"); LockControl(); } if (cbOption_GiangDay.Text.Equals("Mã lớp học")) { DATA.SqlConn sql = new DATA.SqlConn(); string tb = "GiangDay"; string key = "malop"; dgvGiangDay.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_GiangDay.Text.Trim() + "%'"); LockControl(); } if (cbOption_GiangDay.Text.Equals("Mã môn học")) { DATA.SqlConn sql = new DATA.SqlConn(); string tb = "GiangDay"; string key = "mamonhoc"; dgvGiangDay.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_GiangDay.Text.Trim() + "%'"); LockControl(); } }
private void btnSearch_ChucVu_Click(object sender, EventArgs e) { if (cbOption_ChucVu.Text.Equals("")) { MessageBox.Show("Chọn tiêu chí cần sắp xếp", "ERROR!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (cbOption_ChucVu.Text.Equals("Mã chức vụ")) { DATA.SqlConn sql = new DATA.SqlConn(); string tb = "ChucVu"; string key = "machucvu"; dgvChucVu.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_ChucVu.Text.Trim() + "%'"); LockControl(); } }