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;
}
