DataTable Data List with Related Column on Asp.Net

Question

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 ?

Manas Mohapatra · 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); } }