Extract a list a of data and then divide it as needed

[robot_robot]

Hello, please could u help me?
I have to extract a list of employees from a database who fulfill their job anniversary within this month, but them all are part of three different locations/states of the company.
I need to send an e-mail in the 1st day of the month which contain the list of employees of the same state to its correspondent HR department. How to can divide the first extracted list (all of them) in three ones and then send them through email to the correct HR email address (having 3 of them as per being 3 different states) .

[Anil_G (Anil Gorthi)]

@robot_robot

Check this…I believe its same but differnet columns

Divide a database based on an attribute and then send them thru email

@robot_robot Get all the data say into datatable dt Then dt.AsEnumerable.GroupBy(function(x) x(“Managercolumnanme”).ToString) will group the data by managers…pass this in the in argument of for loop and change type argument of for loop to enumerable(of datarow) So inside loop eqch iteration you will get the grouped data for each manager Cheers

Cheers