public void InitDropDownList_Season(CostumeGuide_Dlg owner, ref DropDownList DDL_Season) { List <byte> seasonList = NrTSingleton <NrTableSolGuideManager> .Instance.GetSeasonList(); if (seasonList == null || DDL_Season == null || owner == null) { Debug.LogError("ERROR, CostumeGuide_Dlg.cs, SetDropDownList_Season(), solSesonList or DDL_Season or owner is Null"); return; } DDL_Season.SetViewArea(seasonList.Count + 1); DDL_Season.Clear(); ListItem listItem = new ListItem(); listItem.Key = owner.ENTIRE_SEASON; listItem.SetColumnStr(0, NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("1943")); DDL_Season.Add(listItem); string empty = string.Empty; foreach (byte current in seasonList) { ListItem listItem2 = new ListItem(); listItem2.Key = current; NrTSingleton <CTextParser> .Instance.ReplaceParam(ref empty, new object[] { NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("2302"), "count", current.ToString() }); listItem2.SetColumnStr(0, empty); DDL_Season.Add(listItem2); } DDL_Season.RepositionItems(); DDL_Season.SetFirstItem(); }
public void InitDropDownList_Setorder(CostumeGuide_Dlg owner, ref DropDownList DDL_Setorder) { DDL_Setorder.SetViewArea(3); DDL_Setorder.Clear(); ListItem listItem = new ListItem(); listItem.Key = SolGuideSlot.SLOTTYPE_GRADE_ASCENDING; listItem.SetColumnStr(0, NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("1891")); DDL_Setorder.Add(listItem); ListItem listItem2 = new ListItem(); listItem2.Key = SolGuideSlot.SLOTTYPE_GRADE_DESCENDING; listItem2.SetColumnStr(0, NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("1892")); DDL_Setorder.Add(listItem2); ListItem listItem3 = new ListItem(); listItem3.Key = SolGuideSlot.SLOTTYPE_NAME; listItem3.SetColumnStr(0, NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface("1890")); DDL_Setorder.Add(listItem3); DDL_Setorder.RepositionItems(); DDL_Setorder.SetFirstItem(); owner._currentSort = COSTUME_SORT.SLOTTYPE_GRADE_ASCENDING; }
public void GetDropDownList() { //Pass your data base connection string here using (SqlConnection c = new SqlConnection("Data Source = XE - PC; Initial Catalog = EmployeeApp; Integrated Security = True")) //Pass your SQL Query and above created SqlConnection object "c" using (SqlCommand cmd = new SqlCommand("SELECT Name FROM CompanyTable", c)) { using (SqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { DropDownList.Add(rdr["Name"].ToString()); } } } }
private void AddCompleteCombinationItem(DropDownList solCompleteCombinationDDL, Dictionary <int, string> complteCombinationDic) { int num = 0; foreach (KeyValuePair <int, string> current in complteCombinationDic) { ListItem listItem = new ListItem(); listItem.Key = current.Key; string textFromInterface = NrTSingleton <NrTextMgr> .Instance.GetTextFromInterface(current.Value); listItem.SetColumnStr(0, textFromInterface); this._listItemInfo.Add(num++, current.Key); solCompleteCombinationDDL.Add(listItem); } solCompleteCombinationDDL.RepositionItems(); }