private void frm_BanHang_Load(object sender, EventArgs e)
{
String sql = "select * from DANHMUCBANH";
DataTable tb = genericDatabase.LoadTable(sql);
dataGridView_chonbanh.DataSource = tb;
}
private void frm_NguyenLieu_Load(object sender, EventArgs e)
{
string sql = "select * from NGUYENLIEU";
DataTable table = gen.LoadTable(sql);
dataGrid.DataSource = table;
}
private void frm_DanhMuc_Load(object sender, EventArgs e)
{
string sql = "select * from DANHMUCBANH";
DataTable tb = genericDatabase.LoadTable(sql);
dataGridViewDanhmuc.DataSource = tb;
}
private void frm_ChonBanh_Load(object sender, EventArgs e)
{
string sql = "select * from DANHMUCBANH";
DataTable tb = genericDatabase.LoadTable(sql);
listBoxBanh.DataSource = tb;
listBoxBanh.DisplayMember = "TENBANH";
listBoxBanh.ValueMember = "MSB";
}
private void frm_KhachHang_Load(object sender, EventArgs e)
{
string query = "select * from KhachHang";
dataGridView_QLKhachHang.DataSource = genericDatabase.LoadTable(query);
}
private void frm_NhanVien_Load(object sender, EventArgs e)
{
dataGridView_nhanvien.DataSource = genericDatabase.LoadTable("select * from NHANVIEN");
}
public void Load_Combo()
{
comboBox_KhachHang.DataSource = genericDatabase.LoadTable("select * from KhachHang");
comboBox_KhachHang.ValueMember = "MAKHACHHANG";
comboBox_KhachHang.DisplayMember = "MAKHACHHANG";
}