private void cboclientname_SelectedIndexChanged(object sender, EventArgs e) { if (formload) { cboCustomer = UIControlSupport.SetComboBoxEx(cboCustomer, Utils.GetDataTable("SELECT DISTINCT customer_name,client FROM GLOBAL_producttrans PT JOIN global_sdrrmaster SM ON PT.sdrrno = SM.sdrrno WHERE client = '" + cboclientname.SelectedValue + "' ORDER BY customer_name"), "customer_name", "customer_name", "customer_name", AutoCompleteSource.ListItems, AutoCompleteMode.SuggestAppend, ComboBoxStyle.DropDown); cboCustomer.DropDownWidth = 450; cboCustomer.DropDownHeight = 150; } }
public NewNUDtransControl(String EntryType, String NUDINDEX) { InitializeComponent(); _nudindex = NUDINDEX; _entrytype = EntryType; _invoice = new Dictionary <string, List <string> >(); Utils.printpreview_formuse = "NewNUDtransControl"; cboclientname = UIControlSupport.SetComboBoxEx(cboclientname, Utils.GetDataTable("SELECT * FROM base_client ORDER BY clientcode"), "clientcode,clientname", "clientname", "clientcode", AutoCompleteSource.ListItems, AutoCompleteMode.SuggestAppend, ComboBoxStyle.DropDown); cboclientname.DropDownWidth = 450; cboclientname.DropDownHeight = 150; cboclientname.DropDownStyle = ComboBoxStyle.DropDownList; cboCustomer = UIControlSupport.SetComboBoxEx(cboCustomer, Utils.GetDataTable("SELECT DISTINCT customer_name,client FROM GLOBAL_producttrans PT JOIN global_sdrrmaster SM ON PT.sdrrno = SM.sdrrno WHERE client = '" + cboclientname.SelectedValue + "' ORDER BY customer_name"), "customer_name", "customer_name", "customer_name", AutoCompleteSource.ListItems, AutoCompleteMode.SuggestAppend, ComboBoxStyle.DropDown); cboCustomer.DropDownWidth = 450; cboCustomer.DropDownHeight = 150; display_NUDColums(); }