How to get data

Ramco Ramco

3y781.NET

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 objGroup = bALGroup.GetGroupList("Group");
                if (objGroup != null)
                {
                    List GroupCollection = new List();
                    foreach (var colum in objGroup)
                    {
                        GroupCollection.Add(colum.GroupName.ToString());
                    }
}

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty3y ago

Accepted 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 Shukla3y ago
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
}

0