//@SetSearchAutocomplete public void setSearchAutoCompletion() { //@reset try { //dr.Close() My.MyProject.Forms.MainComponentForm.AutocompleteSearch.Items = new string[] { "" }; My.MyProject.Forms.MainComponentForm.AutocompleteSearch.SetAutocompleteMenu(My.MyProject.Forms.MainComponentForm.txtSearch, My.MyProject.Forms.MainComponentForm.AutocompleteSearch); var da_meb = Module1.getSqlDataAdapter("Select [S_ID] from Sell_BillMember"); DataSet ds_meb = new DataSet(); Module1.ClearTables(ds_meb, "Search_Bill_Member"); da_meb.Fill(ds_meb, "Search_Bill_Member"); if (ds_meb.Tables["Search_Bill_Member"].Rows.Count > 0) { for (int i = 0; i <= ds_meb.Tables["Search_Bill_Member"].Rows.Count - 1; i++) { AutocompleteMenuNS.AutocompleteItem itemAuto = new AutocompleteMenuNS.AutocompleteItem(); var dtSet = ds_meb.Tables["Search_Bill_Member"].Rows[i]; itemAuto.Text = dtSet[0].ToString(); itemAuto.ToolTipText = "Search By Sell Package ID " + itemAuto.Text; itemAuto.ToolTipTitle = "Search A Sell Package By ID"; My.MyProject.Forms.MainComponentForm.AutocompleteSearch.AddItem(itemAuto); } } My.MyProject.Forms.MainComponentForm.AutocompleteSearch.Update(); Module1.ClearReader(ds_meb, da_meb); } catch (Exception ex) { } }
public void initializeData() { SqlDataAdapter dap = new SqlDataAdapter("Select * from Package", Module1.conn); DataSet dsp = new DataSet(); dap.Fill(dsp, "P"); cbPackageID.DataSource = dsp.Tables[0]; cbPackageID.DisplayMember = "P_Name"; cbPackageID.ValueMember = "P_ID"; this.MemberAutoID.SetAutocompleteMenu(txtSellMID, MemberAutoID); SetAutocompleteMemberID(); setAutoID(); setPrice(); Module1.ClearReader(dsp, dap); }
public void setSearchAutoCompletion() { //@reset //dr.Close() try { My.MyProject.Forms.MainComponentForm.AutocompleteSearch.Items = new string[] { "" }; My.MyProject.Forms.MainComponentForm.AutocompleteSearch.SetAutocompleteMenu(My.MyProject.Forms.MainComponentForm.txtSearch, My.MyProject.Forms.MainComponentForm.AutocompleteSearch); var da_meb = Module1.getSqlDataAdapter("Select [MID] , [Licence] , [LicenceName] from Member_Detail"); DataSet ds_meb = new DataSet(); Module1.ClearTables(ds_meb, "Search_members"); da_meb.Fill(ds_meb, "Search_members"); if (ds_meb.Tables["Search_members"].Rows.Count > 0) { for (int i = 0; i <= ds_meb.Tables["Search_members"].Rows.Count - 1; i++) { AutocompleteMenuNS.AutocompleteItem itemAuto = new AutocompleteMenuNS.AutocompleteItem(); var dtSet = ds_meb.Tables["Search_members"].Rows[i]; itemAuto.Text = dtSet[0].ToString(); itemAuto.ToolTipText = "Search By ID " + itemAuto.Text; itemAuto.ToolTipTitle = "Search A Member By ID"; My.MyProject.Forms.MainComponentForm.AutocompleteSearch.AddItem(itemAuto); itemAuto = new AutocompleteMenuNS.AutocompleteItem(); //license itemAuto.Text = dtSet[1].ToString(); itemAuto.ToolTipText = "Search By Licence " + itemAuto.Text; itemAuto.ToolTipTitle = "Search A Member By Licence"; My.MyProject.Forms.MainComponentForm.AutocompleteSearch.AddItem(itemAuto); //license name itemAuto = new AutocompleteMenuNS.AutocompleteItem(); //license itemAuto.Text = dtSet[2].ToString(); itemAuto.ToolTipText = "Search By LicenceName " + itemAuto.Text; itemAuto.ToolTipTitle = "Search A Member By LicenceName"; My.MyProject.Forms.MainComponentForm.AutocompleteSearch.AddItem(itemAuto); } } My.MyProject.Forms.MainComponentForm.AutocompleteSearch.Update(); Module1.ClearReader(ds_meb, da_meb); } catch (Exception ex) { } }