Send email by group from a datatable

[ppr (Peter Preuss)]

its a group by case

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…

On the begin also a Non-LINQ approach is presented

row in dtData.DefaultView.ToTable(True, {“IID”})

so the data will be grouped by IID column
Within the group member processing the email body can be constructed e.g. by concatenation of the group member column values or taking the datatable with only the group related rows