// Fill data into Any Combobox
private void FillCombobox()
{
DatabaseLayer.DataCenter dc = new DatabaseLayer.DataCenter();
// เติมข้อมูลใส่ combobox budgettype บันทึกโดยใช้ combobox.SelectedValue
DataTable dtBudget = dc.ComboboxHelper(cmbBudgetType, "budgetType", "---เลือกรายการ---", "select budget_id, budgetType from budget");
cmbBudgetType.DataSource = dtBudget;
cmbBudgetType.DisplayMember = "budgetType";
cmbBudgetType.ValueMember = "budget_id";
// เติมข้อมูลใส่ combobox howtobuy บันทึกโดยใช้ combobox.SelectedValue
DataTable dtHTB = dc.ComboboxHelper(cmbHowtobuy, "htbName", "---เลือกรายการ---", "select htb_id, htbName from howtobuy");
cmbHowtobuy.DataSource = dtHTB;
cmbHowtobuy.DisplayMember = "htbName";
cmbHowtobuy.ValueMember = "htb_id";
}
private void FillCombobox()
{
DatabaseLayer.DataCenter dc = new DatabaseLayer.DataCenter();
// เติมข้อมูลใส่ combobox cmbDruggroup บันทึกโดยใช้ combobox.SelectedValue
DataTable dtDruggroup = dc.ComboboxHelper(cmbDruggroup, "druggroupName", "---เลือกรายการ---", "select druggroup_id, druggroupName from druggroup");
cmbDruggroup.DataSource = dtDruggroup;
cmbDruggroup.DisplayMember = "druggroupName";
cmbDruggroup.ValueMember = "druggroup_id";
// เติมข้อมูลใส่ combobox cmbDruggroup บันทึกโดยใช้ combobox.SelectedValue
DataTable dtDrugtype = dc.ComboboxHelper(cmbDrugtype, "typeName", "---เลือกรายการ---", "select type_id, typeName from type");
cmbDrugtype.DataSource = dtDrugtype;
cmbDrugtype.DisplayMember = "typeName";
cmbDrugtype.ValueMember = "type_id";
}
private void frmSaleProducts_Load(object sender, EventArgs e)
{
DatabaseLayer.DataCenter dc = new DatabaseLayer.DataCenter();
// เติมข้อมูลใส่ combobox Department บันทึกโดยใช้ combobox.SelectedValue
DataTable dtDepartment = dc.ComboboxHelper(cmbDepartment, "departmentName", "---เลือกรายการ---", "SELECT department_id, departmentName FROM department");
cmbDepartment.DataSource = dtDepartment;
cmbDepartment.DisplayMember = "departmentName";
cmbDepartment.ValueMember = "department_id";
FillData();
}