Query To Count Number Of Requester For Each Priority Type

[MAHESH1 (MAHESHKUMAR JV)]

@Debasmita

Dictionarty=( From p in dta.Select
group p by Department=p.Item("Priority") Into GroupA=Group
Select GroupA).ToDictionary(Function(x) x(0)("Priority").ToString, Function(x) Convert.ToString(x.Count))) 

Now you can access the count by using the priority.

Refer this post for more details

How to get data in column based on another column field

@saraawq Declaration DataTable Variable as dta Dictionary(Of string, Of string) as Dictionary Query Dictionarty=( From p in dta.Select group p by Department=p.Item("DEPARTMENT") Into GroupA=Group Select GroupA).ToDictionary(Function(x) x(0)("DEPARTMENT").ToString, Function(x) Convert.ToString(x.Sum(Function(y) Convert.ToDouble(y.Item("Work HR").ToString)))) Now the Key value of the Dictionary will be Department and the Value will be sum of working hours of that particular Department. So Y…

Regards,
Mahesh