每个科目都单独计算,比如
For Each s As String In lst
drs = DataTables("学生成绩统计表").Select("班级='" & s & "'","语文_分数")
For i As Integer = 0 To drs.Count - 1
drs(i)("语文_班名") = i + 1
Next
Next
For Each s As String In lst
drs = DataTables("学生成绩统计表").Select("班级='" & s & "'","数学_分数")
For i As Integer = 0 To drs.Count - 1
drs(i)("数学_班名") = i + 1
Next
Next