private void btn_timkiem_Click_1(object sender, EventArgs e) { KETNOICSDL_ROOM.taoketnoi(); dtgrview_phongtimkiem.DataSource = null; string sql_Statement = "select * from ROOM where MA_PHONG like '" + txt_timkiem.Text + "' or TEN_PHONG like '" + txt_timkiem.Text + "' or MA_LOAI like '" + txt_timkiem.Text + "' or SUC_CHUA like '" + txt_timkiem.Text + "' or GĐ like '" + txt_timkiem.Text + "'"; dtgrview_phongtimkiem.DataSource = KETNOICSDL_ROOM.laydulieu(sql_Statement, "ROOM"); }
private void Load_DuLieu(object sender, EventArgs e) { dtgrview_phonginfo.DataSource = null; string SQL = "Select * from ROOM"; dtgrview_phonginfo.DataSource = null; dtgrview_phonginfo.DataSource = KETNOICSDL_ROOM.loaddulieu(SQL, "ROOM"); HienThi_DL(); }
private void btn_chen_Click(object sender, EventArgs e) { try { string a = txt_maphong.Text; string b = txt_tenphong.Text; string c = txt_maloai.Text; string a1 = txt_succhua.Text; string a2 = txt_gd.Text; KETNOICSDL_ROOM.chendulieu(a, b, c, a1, a2); Load_DuLieu(null, null); } catch (OleDbException Exception) { String a = Convert.ToString(Exception.ErrorCode); MessageBox.Show(a); } }
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"); }
public FrmPhongsearch() { InitializeComponent(); KETNOICSDL_ROOM.taoketnoi(); }
private void btn_luu_Click(object sender, EventArgs e) { KETNOICSDL_ROOM.luudulieu(txt_maphong.Text, txt_tenphong.Text, txt_maloai.Text, txt_succhua.Text, txt_gd.Text); Load_DuLieu(null, null); }
private void btn_xoa_Click(object sender, EventArgs e) { KETNOICSDL_ROOM.xoadulieu(txt_maphong.Text); Load_DuLieu(null, null); }