private void btn_timkiemlop_Click(object sender, EventArgs e)
{
KeyNoiCSDL_LOP.KetNoi_CSDL();
grdtimkiem.DataSource = null;
string sql2 = "SELECT * FROM LOP WHERE MA_LOP like'" + txt_timkiem.Text + "' or TEN_LOP like '%" + txt_timkiem.Text + "%' or MA_GV like '" + txt_timkiem.Text + "'";
grdtimkiem.DataSource = KeyNoiCSDL_LOP.LoadDuLieu(sql2, "LOP");
}
private void Load_DuLieu(object sender, EventArgs e)
{
DataGvLop.DataSource = null;
string SQL = "Select * from LOP";
DataGvLop.DataSource = null;
DataGvLop.DataSource = KeyNoiCSDL_LOP.LoadDuLieu(SQL, "LOP");
HienThi_DL();
}
private void load(object sender, EventArgs e)
{
string sql = "SELECT * from TKB";
grd_tkb.DataSource = null;
grd_tkb.DataSource = ketnoiCSDL_TKB.laydl(sql, "TKB");
string SQL = "Select * from LOP";
grd_lop.DataSource = null;
grd_lop.DataSource = KeyNoiCSDL_LOP.LoadDuLieu(SQL, "LOP");
string SQL1 = "Select * from QLTTB";
grd_TB.DataSource = null;
grd_TB.DataSource = KetNoiCSDL_TB.LoadDuLieu(SQL1, "QLTTB");
string SQL2 = "Select * from ROOM";
grd_room.DataSource = null;
grd_room.DataSource = KETNOICSDL_ROOM.laydulieu(SQL2, "ROOM");
}