Groupby in Datatable using compute

ishamaurya

I have a datatable containing 3 columns and several rows eg
table dtgroups
Name Score1 Score 2
A 10 20
20 30
C 10 20
A 11 33
B 11 10
20 20
B 11 10

In the above table in column name i have A,B,C and " " rows.I want to use compute function get the result
Name Score1 Score 2
A 21 53
B 22 20
C 10 20
31 40

But i am unable to get the sum of score1 and score 2 for the row ""
Can any one help me out?

koosvdkolk

I would do this in (My)SQL, and not in Javascript. Do you happen to get the data from a database?

In what form do you have your data before you make a DataTable with it?

ishamaurya

i am using vb.net