Maximum Occurrence of a value in a column datatable

[Shaeen_Shah]

Any help here …

[nikhil.girish]

Hi @Shaeen_Shah

Seems like you have a post already created by you on this topic

Kindly close any one if you are ok with the solution

Nevertheless
Still sharing here

[nikhil.girish]

How can i find the Maximum Occurrence of a value in a column of a datatable

Hi, If you want to get the most occurrence values in a column, the following will help you. Value dt.AsEnumerable.GroupBy(Function(r) r("ColumnName").ToString).OrderBy(Function(g) g.Count).Last().First().Item("ColumnName").ToString() Count dt.AsEnumerable.GroupBy(Function(r) r("ColumnName").ToString).OrderBy(Function(g) g.Count).Last().Count Regards,

Hope this helps

[Shaeen_Shah]

Sorry , will try to recall any one

Thanks the logic is working now