How to group multiple array of object in c#

Question

Hi I am trying to group an array of objects and sum the result of each grouped value. object[] products = { new object[] {Soap 1 10} new object[] { Soap 2 20 } new object[] { Soap1 112 } new object[] { Soap 330 } new object[] { Soap2 2 10} new object[] { Soap1 2 40} }; I need the output to be like Soap 1 10 Soap 2 20 Soap 3 30 ------------------- Total 50 ------------------- Soap1 1 12 Soap1 2 40 ------------------- Total 52 -------------------- Soap2 2 10 ------------------ Total 10 --------------------

Tapan Patel · Answer

you can do something like below to group the items. (working with object array could be pain sometimes) object [] products = { new object [] { Soap  1 10} new object [] { Soap  2  20 } new object [] { Soap1  1 12 } new object [] { Soap  3 30 } new object [] { Soap2  2 10} new object [] { Soap1  2 40} }; var temp = products.Select(obj => new { Name = (( object [])obj)[0] ID = (( object [])obj)[1] Amt= (( object [])obj)[2] }); var grp = temp.GroupBy(x => x.Name).Select(y => new { Name = y.Key CNT = y.Sum(t => ( int )t.Amt) }); Output:

Gautam Parmar · Answer

Use angularJs Table for first output and filter for 2nd output