Dim yy As String = e.DataCol.name.SubString(2,4) If e.DataCol.name Like "TX" & yy & "年%月" Then Dim dcm As Decimal = 0 For Each dc As DataCol In e.DataTable.DataCols If dc.Name Like "TX" & yy & "年%月" Then dcm = dcm + e.DataRow(dc.Name) End If Next e.DataRow("TX" & yy & "年合计")= dcm End If