// 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(); }