Update a Datatable row values based on condition

[ppr (Peter Preuss)]

We could think about:

• Grouping the data by Name
• Process all groupmembers
• When any member of a group fails, then set the status to all

[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…

We recommend to work on Datarow levels eg Groups = List(Of List(Of DataRow)) as a heavy CopyToDataTable will get lost the origin DataTable Identities

Assign Activity:
Groups | List(Of List(Of DataRow)) =

(From d in yourDataTableVar.AsEnumerable
Group d by k=d("Name").ToString.Trim into grp=Group
Select g = grp.ToList).ToList

For each Activity | grp in Groups | TypeArgument: List(Of DataRow)

• For each Activity | mbr = gpr | TypeArgument: DataRow
  • Process the members (e.g. Account number), track the status and break innerloop by issues
• For each Activity | mbr2 = gpr | TypeArgument: DataRow
  • Set the status to all members from the group