Loading

DataTable Data List with Related Column on Asp.Net

DataTable Data List with Related Column on Asp.Net

Ekrem Tapan

Ekrem Tapan

10y752.NET

I`m already have a below table on SQL

PARENT_CODE CHILD_CODE ATTRIBUTE_NAME ATTRIBUTE_DESCRIPT R_YEAR
------------- ------------ -------------- ------------------ -----------
1 001 ATT1 Description1 2016
1 001 ATT2 Description2 2016
1 001 ATT3 Description3 2016
1 001 ATT4 Description4 2016
1 001 ATT5 Description5 2016
1 001 ATT6 Description6 2016
1 002 ATT1 Description1 2016
1 002 ATT2 Description2 2016
1 002 ATT3 Description3 2016
1 002 ATT4 Description4 2016
2 003 ATT1 Description1 2016
2 003 ATT2 Description2 2016
2 003 ATT3 Description3 2016
2 003 ATT4 Description4 2016

How can i show on like that below format ?

1 - 001 :
ATT1 : Description1
ATT2 : Description2
ATT3 : Description3
ATT4 : Description4
ATT5 : Description5
ATT6 : Description6
1 - 002 :
ATT1 : Description1
ATT2 : Description2
ATT3 : Description3
ATT4 : Description4
2 - 003 :
ATT1 : Description1
ATT1 : Description2
ATT1 : Description3
ATT1 : Description4

i know can we use LinQ or foreach loop will be get result, but i don`t have an any idea how can i make it.

anyone can help ?

1 Reply

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

Manas Mohapatra10y ago
Accepted answer
You need to use both LINQ and foreach loop to accomplish your result:
DataTable dt = new DataTable(); // Load data from Database

var groupedData = from b in dt.AsEnumerable()
                  group b by b.Field<string>("CHILD_CODE") into g
                  select new
                  {
                      ChildCode = g.Key,
                      Count = g.Count(),
                      Records = g.ToList()
                  };

// Loop over grouped data and see result

forach(var p in groupedData)
{
    forach(var tempRec in p.Records)
    {
        Console.WriteLine(tempRec.ChildCode);
        Console.WriteLine(tempRec.Parent_Code);
    }
}
+2