62,046
社区成员
发帖
与我相关
我的任务
分享请问如何才能将datagrid控件绑定到带有"COMPUTE"子句的sql语上?
例如
SELECT TOP 100 PERCENT hh_id, number, dj, (dj * number) AS 金额, storageCode
FROM dbo.kcdamx
ORDER BY hh_id, storageCode
COMPUTE sum(dj * number) by hh_id
SELECT TOP 100 PERCENT hh_id, number, dj, (dj * number) AS 金额, storageCode
FROM dbo.kcdamx
ORDER BY hh_id, storageCode
COMPUTE sum(dj * number) by hh_id
...全文
请发表友善的回复…
发表回复
聊产品敲代码的项目经理 2002-12-23
- 打赏
- 举报
qiushuiwuhen(秋水无恨)
谢谢
谢谢
qiushuiwuhen 2002-12-21
- 打赏
- 举报
http://aspalliance.com/olson/articles/Summary.aspx
用rollup好做，但rollup和Compute有很大不同，返回的记录集不同
用rollup好做，但rollup和Compute有很大不同，返回的记录集不同
saucer 2002-12-20
- 打赏
- 举报
see
Summary Rows in DataGrid Controls
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndive/html/data01102002.asp
Summary Rows in DataGrid Controls
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndive/html/data01102002.asp
龙腾九霄 2002-12-20
- 打赏
- 举报
sql command only return sql dataset nomatter that you use compute phrase or not.
and only try to bind column data to datagrid.
Good luck!
and only try to bind column data to datagrid.
Good luck!
聊产品敲代码的项目经理 2002-12-20
- 打赏
- 举报
没有人会吗?
