Linq query for groupby and sum

Help Studio
13

@GBK I have extended your query for other columns as below. But If any columns are having empty values, it is throwing exception. How can I prevent this issue?

dtResults = (From dte In dtTable.AsEnumerable
Group dte By col1=dte(2).ToString.Trim Into Group
Select dtResults.Rows.Add({col1, Group.Sum(Function (x) CInt(x(1).toString.Trim)), Group.Sum(Function (x) CInt(x(2).toString.Trim)) , Group.Sum(Function (x) CInt(x(3).toString.Trim))})).CopyToDataTable

Exception: Conversion from string “” to type ‘Double’ is not valid.

1 Like