How to Count the data of one column in data table w.r.t other column?

[TimK (Tim Kok)]

Without more information, it sounds like you want to simply find how many employees are hired at each site?

FILTER AND COUNT WITH LINQ

the dictionary approach: dictCValCount | Dictionary(Of String, Int32) = (From d in dtData.asEnumerable Group d by k=d(“C”).toString.Trim into grp=Group Select t= Tuple.Create(k, grp.Count)).ToDictionary(Function (x) x.Item1, Function (x) x.Item2) With a prepared datatable, having 2 cols, Key, Count - dtStatistic we can do: dtStatistic = (From d in dtData.asEnumerable Group d by k=d(“C”).toString.Trim into grp=Group Let ra = new Object(){k, grp.Count} Select r= dtStatistic.Rows.Add(ra))…

You could look at using something like this?