主题：某个值写入汇总行

Dim cmd As new SQLCommand
cmd.C
cmd.CommandText = "s elect 余额 from 出入库 where [_sortkey] = (s elect Max(_sortkey) from 出入库) "
Dim it As Integer = cmd.ExecuteScalar

怎样把返回的it值写入下面的总计汇总行的余额里面

g = New Subtotalgroup
g.Aggregate = AggregateEnum.Count
g.GroupOn = "*"
g.TotalOn = "余额"
g.Caption = "余额总计"
t.SubtotalGroups.Add(g)