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
.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…