I need to group this data according to the status.
I need to group this data according to the status. And then if two statuses belonging to the same MailUID are found; I want it to write the value that is “folderx”, not the value that is Success.
The linq expression I used is below. How do I do that?
(
From x In dt_DataTable
Group x By a = x("MailUID").ToString.Trim, b = x("Status").ToString.Trim Into Group
Select dt_DataTable.Rows.Add(a,b)
).CopyToDataTable