Grouping of list values

sathish

3y1.1kC#

Hi,

I have a list with users and orders in one list like below

user 1	order1
user 1	order2
user 1	order3
user2	order2
user2	order3

From here I have form as user1 with his orders list (1,2,3) as one group and user2 as (2,3) with another in C#

Thanks

6 Replies

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

Jignesh Kumar3y ago

Accepted answer

 foreach (var item in myDictionary)
            {
                var user = item.Key;
                var userOrder = item.Value;
                foreach (var order in item.Value)
                {
                    var oderforUser = order.OrderNumber;
                }
            }

you can iterate using above code

sathish3y ago
Thanks Jignesh.

How this iterated values to be loaded to the existing HTML table

Thanks
+3
sathish3y ago
Hi,

How to iterate this one and as per user and respective orders

Thanks
+3
sathish3y ago
Thanks Jignesh.

And any possibility to pass 'groupByUser' to the list
+4
Aravind Govindaraj3y ago
var ordersByUser = ordercollection.groupby(order=>order.userId);

In orderByUser result, you will get the result as

Item 1 => User 1 => Order1, Order 2, Order 3

Item 2 => User 2 => Order 2 and Order 3
+2

Jignesh Kumar3y ago

Hi Satish,

Please check below code and try ,

public class UserOrder
    {
        public string UserName { get; set; }
        public string OrderNumber { get; set; }

    }

var listOfUserOrders = new List {

                new UserOrder {
                    UserName = "User 1",
                    OrderNumber = "order 1"
                },

                new UserOrder {
                     UserName = "User 1",
                     OrderNumber = "order 2"
                },

                new UserOrder {
                    UserName = "User 1",
                    OrderNumber = "order 3"
                },

                new UserOrder {
                    UserName ="User 2",
                    OrderNumber = "order 2"
                },

                new UserOrder {
                     UserName ="User 2",
                     OrderNumber = "order 3"
                }
            };


Dictionary> myDictionary = listOfUserOrders.GroupBy(x => x.UserName).ToDictionary(g => g.Key, g => g.ToList());