1422
社区成员
- 主页
问大虾们用控件DataGrid时显示合计(select name,sum(bal) from a where name="a"),怎么办?
...全文
请发表友善的回复…
发表回复
playyuer 2001-03-16
select max(name),sum(bal) from a where name="a"
name需要聚集!!!
dim adorecordset as new adodb.recordset
dim cn as new adodb.connection
cn.open "...."
adorecordset.open "select max(name),sum(bal) from a where name='a'",cn
set datagrid1.datasource = adorecordset
name需要聚集!!!
dim adorecordset as new adodb.recordset
dim cn as new adodb.connection
cn.open "...."
adorecordset.open "select max(name),sum(bal) from a where name='a'",cn
set datagrid1.datasource = adorecordset