I have to extract a list of employees from a database who fulfill their job anniversary within this month, but they correspond to different managers dependinfg of the department they work on in the company.
I need to send an e-mail weekly, each Monday to each manager with a list of names to let him know which of his Employees are celebrating their Job Anniversary that week.
How to divide the list of employees extracted based on their manager and then send this list through email to the correct one.
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