public void FillDataToCombo1() { string sql = "select MaNV,TenNV from NhanVien"; DAO.FillDataToCombo(sql, cmbMaNV, "MaNV", "MaNV"); cmbMaNV.SelectedIndex = -1; }
public void FillDataToCombo1() { string sql = "select MaKhach,TenKhach from KhachHang"; DAO.FillDataToCombo(sql, cmbMaKH, "MaKhach", "MaKhach"); cmbMaKH.SelectedIndex = -1; }
public void FillDataToCombo1() { string sql = "select MaNoiThat,TenNoiThat from DMNoiThat"; DAO.FillDataToCombo(sql, cmbMaNoiThat, "MaNoiThat", "MaNoiThat"); cmbMaNoiThat.SelectedIndex = -1; }
private void FillDataToCombo1() { string sql = " select MaNV,TenNV from NhanVien"; DAO.OpenConnection(); DAO.FillDataToCombo(sql, cmbMaNV, "MaNV", "MaNV"); sql = "select MaNCC,TenNCC from NhaCungCap"; DAO.FillDataToCombo(sql, cmbMaNCC, "MaNCC", "MaNCC"); sql = "select MaNoiThat,TenNoiThat from DMNoiThat"; DAO.FillDataToCombo(sql, cmbMaNoiThat, "MaNoiThat", "MaNoiThat"); }
public void FillDataToCombo1() { string sql = " select MaNV,TenNV from NhanVien"; DAO.OpenConnection(); DAO.FillDataToCombo(sql, cmbMaNV, "MaNV", "MaNV"); sql = "select MaKhach,TenKhach from KhachHang"; DAO.FillDataToCombo(sql, cmbMaKH, "MaKhach", "MaKhach"); sql = "select MaNoiThat,TenNoiThat from DMNoiThat"; DAO.FillDataToCombo(sql, cmbMaNoiThat, "MaNoiThat", "MaNoiThat"); }
private void frmNhanVien_Load(object sender, EventArgs e) { string Sql = "Select Maca from CaLam"; DAO.OpenConnection(); DAO.FillDataToCombo(Sql, cmbMaCa, "Maca", "Tenca"); Sql = "Select MaCV from CongViec"; DAO.OpenConnection(); DAO.FillDataToCombo(Sql, cmbMaCV, "MaCV", "TenCV"); LoadDataToGridView(); DAO.CloseConnection(); }
private void DMNoiThat_Load(object sender, EventArgs e) { String Sql = "Select MaLoai, TenLoai from TheLoai"; DAO.OpenConnection(); DAO.FillDataToCombo(Sql, cmbMaLoai, "MaLoai", "TenLoai"); Sql = "Select MaKieu, TenKieu from KieuDang"; DAO.FillDataToCombo(Sql, cmbMaKieu, "MaKieu", "TenKieu"); Sql = "Select MaMau, TenMau from MauSac"; DAO.FillDataToCombo(Sql, cmbMaMau, "MaMau", "TenMau"); Sql = "Select MaChatLieu, TenChatLieu from ChatLieu"; DAO.FillDataToCombo(Sql, cmbMaChatLieu, "MaChatLieu", "TenChatLieu"); Sql = "Select MaNuocSX, TenNuocSX from NuocSanXuat"; DAO.FillDataToCombo(Sql, cmbMaNuocSX, "MaNuocSX", "TenNuocSX"); LoadDataToGridView(); }
private void cmbTim_DropDown(object sender, EventArgs e) { DAO.FillDataToCombo("SELECT SoHDN FROM HoaDonNhap", cmbTim, "SoHDN", "SoHDN"); cmbTim.SelectedIndex = -1; }
private void cmbTim_DropDown(object sender, EventArgs e) { DAO.FillDataToCombo("SELECT SoDDH FROM DonDatHang", cmbTim, "SoDDH", "SoDDH"); cmbTim.SelectedIndex = -1; }