C# (CSharp) GuestHouse Dom_SqlClass.FillItemToCombobox Examples

Example #1

File: Expense.cs Project: Chimchanoudom/MIS

 private void Expense_Load(object sender, EventArgs e)
 {
     ID         = dom_Design.GenerateID(Dom_SqlClass.GetIDFromDB("ExpID", "_", "Expense"), "EXP_00");
     txtID.Text = ID;
     Dom_SqlClass.FillItemToCombobox("SELECT ExpTypeID,ExpDesc FROM ExpenseType", "ExpTypeID", "ExpDesc", cmType);
 }

Example #2

 void FillItem()
 {
     Dom_SqlClass.FillItemToCombobox(@"SELECT CusID,CONCAT(Customer.Fname,' ',Customer.Lname) AS 'fullName' FROM Customer;", "CusID", "fullName", cmCustomer);
 }