How to group multiple array of object in c#

Vasanthkumar Porcheziyan

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", "1",12 },

new object[] { "Soap", "3",30 },

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

--------------------

2 Replies

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

Tapan Patel9y ago
Accepted 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:
0
Gautam Parmar9y ago
Use angularJs Table for first output and filter for 2nd output
0