Grouping for 2 colunms

Help
1

Hi Friends,
I need to grouping for 2 columns… (State and Email id)

Emp_Number State Email id
101 KA KA@mail.com

102 TN KA@mail.com

103 KA KA@mail.com

104 RR TN@mail.com

105 TN TN@mail.com

106 RR TN@mail.com

107 US UP@mail.com

108 UP UP@mail.com

out of grouping

101 KA KA@mail.com
103 KA KA@mail.com

102 TN KA@mail.com

104 RR TN@mail.com
106 RR TN@mail.com

105 TN TN@mail.com

107 US UP@mail.com

108 UP UP@mail.com

Already am using – grouping for only one column(Email)
dtUS.AsEnumerable().GroupBy(Function(x As DataRow) x.Item(“Email id”))

dtUS = Data table
now I want add State column also for grouping… please help on this….

2

Hi. I don’t understand what are you doing. But grouping with two columns is very easy

dtUs.AsEnumerable.GroupBy(Function(x) New With { Key .Email = x.Item(“Email id”).ToString, Key .State = x.Item(“State”).ToString})

3

Hi
Can you take look. It will help you

Regards
balamurugan

4

how to group by 2 columns or more?