select OLDTXCODE,OPERATORNO,COUNT(amount) as 交易笔数 ,sum(cast(amount as bigint)) as 总金额 from dbo.View_ZSB group by OLDTXCODE,OPERATORNO 请教下, ,COUNT(amount),sum(cast(amount as bigint)) 把这两个统计的数据, 怎么绑定到gridView上 OLDTXCODE OPERATORNO 交易笔数 总金额 1 101 3 450
[Quote=引用楼主 ct_edlson 的回复:]
select OLDTXCODE,OPERATORNO,COUNT(amount) as 交易笔数 ,sum(cast(amount as bigint)) as 总金额 from dbo.View_ZSB group by OLDTXCODE,OPERATORNO
请教下, ,COUNT(amount),sum(cast(amount as bigint)) 把这两个统计的数据, 怎么绑……
[/Quote]