In the following code for finding sum of Rate colum
n in the DataTable dt
dt.Compute("Sum(Convert(Rate, 'System.Int32'))");
In this is it possible to assign group by clause like SQL
Inn order to get Sum based on a value in another column of the same dt
Fo eg:
----------------------------
Rate | Group
----------------------------
100 | A
120 | B
70 | A
----------------------------
I just wanna to get Sum A=170
an Sum B=120
.