Hi Everyone, My Requirement is i need to group datatable based on a column (Manager Name) and after group i need to sort them based on 2columns in ascending order (service date) and (display name) @ppr @Yoichi @Rahul_Unnikrishnan @Palaniyappan Thanks in Advance

HI, Give the following expression try. dt.AsEnumerable.GroupBy(Function(r) r("Manager Name").ToString()).SelectMany(Function(g) g.OrderBy(Function(r) if(DateTime.TryParse(r("Service Date").ToString,New DateTime),DateTime.Parse(r("Service Date").ToString),DateTime.MinValue)).ThenBy(Function(r) r("D…

Group and sort the datatable using Linq

Help Forum

kavya.s16 (Kavya S16) June 24, 2022, 7:23am 11

@Yoichi its working correctly Thankyou sir!!

1 Like

Group datatable by EmailId and send mail seperately

Topic		Replies	Views
Group By Sort with date col and get First Row off all Group.(Linq) Something Else feedback	13	1469	March 15, 2023
Using datatable Group by 2 columns and sort by 1 column Studio	3	851	October 16, 2020
Sort a datatable based on column name which gives incorrect input string as error Help	24	2353	March 7, 2019
Custom Sort a Datatable using linq Forum datatable , excel , question	8	1368	July 5, 2022
Sorting a DataTable by 2 column, when 1 condition is more important then the second one Help datatable , activities , question	13	3034	February 6, 2020

Most Active Users - Yesterday
Anil_G
ashokkarale
Ajay_Mishra
Gautham_Pattabiraman
BHUSHAN_NAGAONKAR1
vrdabberu
ABHIMANYU_THITE1
lrtetala
samantha_shah
shyamala_shyamu
More details...

Group and sort the datatable using Linq

Related Topics