How to get data

Question

Hi

I have below data

Group 2C

Group 2C(i)

Group 3C

Group 3D

Group 3D(i)

Group 3E

Group 3G

I want to display like below

Group 2C , Group 2C(i)

Group 3C

Group 3D , Group 3D(i)

Group 3E

Group 3G

BALGroup bALGroup = new BALGroup();
                List<Group> objGroup = bALGroup.GetGroupList("Group");
                if (objGroup != null)
                {
                    List<string> GroupCollection = new List<string>();
                    foreach (var colum in objGroup)
                    {
                        GroupCollection.Add(colum.GroupName.ToString());
                    }
}

Thanks

Amit Mohanty · Answer

BALGroup bALGroup = new BALGroup(); List objGroup = bALGroup.GetGroupList("Group"); if (objGroup != null) { var groupedItems = groups.GroupBy(g => g.GroupName.Split('(')[0].Trim()) .Select(g => string.Join(" , ", g.Select(item => item.GroupName))); }

Brahma Prakash Shukla · Answer

BALGroup bALGroup = new BALGroup(); List objGroup = bALGroup.GetGroupList("Group"); if (objGroup != null) { List GroupCollection = new List (); string currentGroup = null; foreach (var column in objGroup) { string groupName = column.GroupName.ToString(); if (groupName.StartsWith("Group")) { if (currentGroup != null && groupName.Contains("(")) { GroupCollection.Add(currentGroup + " , " + groupName); } else { if (currentGroup != null) { GroupCollection.Add(currentGroup); } currentGroup = groupName; } } else { if (currentGroup != null) { GroupCollection.Add(currentGroup); currentGroup = null; } GroupCollection.Add(groupName); } } if (currentGroup != null) { GroupCollection.Add(currentGroup); } // Now you can use the GroupCollection list as desired }

How to get data

Answers (2)