private void NhanVien_Load(object sender, EventArgs e)
{
loatdata();
string sql = "select * from Cong_viec";
DAO.fillDataToCombo(sql, comboBoxmacongviec, "macv", "tencv");//displaymember:chọn tên ,valuemember:lấy mã tương ứng
string sql1 = "select * from ca_lam";
DAO.fillDataToCombo(sql1, comboBoxmaca, "maca", "tenca");
string sql2 = "select distinct gioitinh from Nhan_vien";
DAO.fillDataToCombo(sql2, comboBoxgioitinh, "gioitinh", "gioitinh");
}
public void RefreshData()
{
DAO.OpenConnection();
LoadDataToGridView();
FillDataToCombo();
string sql = "select Maloai,Tenloai from Loai_ga";
DAO.fillDataToCombo(sql, cmbLoaiGas, "Maloai", "Tenloai");
sql = "select Mamau,Tenmau from Mau";
DAO.fillDataToCombo(sql, cmbMau, "Mamau", "Tenmau");
sql = "select Makhoiluong from Khoi_luong";
DAO.fillDataToCombo(sql, cmbKhoiLuong, "Makhoiluong", "Makhoiluong");
sql = "select ManuocSX,TennuocSX from Nuoc_san_xuat";
DAO.fillDataToCombo(sql, cmbNuocSX, "ManuocSX", "TennuocSX");
DAO.CloseConnection();
}
private void HoaDonBan_Load(object sender, EventArgs e)
{
//string abc= "select * from Chi_tiet_hoa_don_ban ";
// fill dữ liệu vào các comboboxmax nv,kh,tenhang,mahang,soluong
string sql = "select MaNV,TenNV from Nhan_Vien";
DAO.OpenConnection();
DAO.fillDataToCombo(sql, cmbMaNV, "MaNV", "MaNV");
sql = "select Makhach,Tenkhach from Khach_hang";
DAO.fillDataToCombo(sql, cmbMaKH, "Makhach", "Makhach");
sql = "select Mabinh,Tenbinh from DM_Binh_ga";
DAO.fillDataToCombo(sql, cmbMabinh, "Mabinh", "Mabinh");
sql = " select SoHDB from hoa_don_ban ";
DAO.fillDataToCombo(sql, cmbMaHDB, "SoHDB", "SoHDB");
Load_DataGridViewChitiet();
}