Comma seperated data in Dropdownlist

Question

Hi Guys, I have one dropdown and I need to display data in dropdown as comma seprated like a,b,c Here is my code: rddlMuster.DataTextField = "ZoneName"; rddlMuster.DataValueField = "ZoneID"; rddlMuster.DataSource = objUtilsDAO.GetZonesByYardID(lstYards.FirstOrDefault().YardID).Where(zm => zm.IsCS == false && zm.ZoneType == (int)Enums.ZoneType.Mustering_Zone).OrderBy(zm => zm.ZoneName); rddlMuster.DataBind(); Can anyone please help me to get comma seprated value in dropdown while working with linq in asp.net?

Sandeep Kumar · Answer

Hi @Hiten Thanks for your mail. Let me explain my reequirement again here by using this query rddlMuster.DataTextField = "ZoneName"; rddlMuster.DataValueField = "ZoneID"; rddlMuster.DataSource = objUtilsDAO.GetZonesByYardID(lstYards.FirstOrDefault().YardID).Where(zm => zm.IsCS == false && zm.ZoneType == (int)Enums.ZoneType.Mustering_Zone).OrderBy(zm => zm.ZoneName); rddlMuster.DataBind(); I am getting output like but my requirement is in dropdown I want value like: Char Muster,Muster 2,Test Mustering,testmuster

Sandeep Kumar · Answer

I have fouund solution for this and solution is var list = objZoneDAO.GetAllZonesByYardID(Convert.ToInt32(rddlYard.SelectedValue)).Where(Z => Z.ZoneType == Convert.ToInt32(Enums.ZoneType.Mustering_Zone) && Z.ZoneStatus == Convert.ToInt32(Enums.ZoneStatus.Active)).ToList(); DataTable dt = new DataTable(); DataRow dr = dt.NewRow(); dr[0] = dt.Columns.Add("ZoneName", typeof(string)); dr[1] = dt.Columns.Add("ZoneId", typeof(string)); string s = string.Empty; string zid = string.Empty; foreach (var item in list) { s += item.ZoneName + ","; zid += item.ZoneID + ","; } s = s.Remove(s.LastIndexOf(',')); zid = zid.Remove(zid.LastIndexOf(',')); dr[0] = s; dr[1] = zid; dt.Rows.Add(dr); rddlMuster.DataTextField = "ZoneName"; rddlMuster.DataValueField = "ZoneId"; rddlMuster.DataSource = dt; rddlMuster.DataBind();

Hiten Pandya · Answer

Hi Sandeep Kumar, Did you get the correct ouput from your query ? If so, then can you tell me the exception that you get and can post your result so,that I can try to find some solution. Thanks.

Sandeep Kumar · Answer

@Hiten Pandya Thanks for your mail. I had already tried this String.Join() like rddlMuster.DataSource = string.Join(",", (objUtilsDAO.GetZonesByYardID(lstYards.FirstOrDefault().YardID).Where(zm => zm.IsCS == false && zm.ZoneType == (int)Enums.ZoneType.Mustering_Zone).OrderBy(zm => zm.ZoneName))); but I am getting Exception

Hiten Pandya · Answer

Hi Sandeep Kumar, If I understand your question correctly then you want string with comma from your linq query and want to pass that as a source for dropdown then you can use, String.Join() which has below arguments, 1. separator means with what sign you want separation 2. array of object,array of string,IEnumerable array of string 3. startindex 4. count For more details please visit below links, https://forums.asp.net/t/1768913.aspx?How+to+create+a+comma+separated+list+using+LINQ+ https://www.dotnetperls.com/string-join Hope you get some hint. Let me know if it does not work for you. Thanks.

Comma seperated data in Dropdownlist

Answers (5)