SQL统计查询在C# winfor前台显示

Question

SQL 统计查询

下面的SQL语句，只有单价，需要统计费用次数和费用总价

 select a.CType as '类别',a.ChargeDetailsName as '费用名称',a.CDPayServiceName as '收费项目',
a.ChargeDetailsPrice as '费用单价',
a.CDExecutiveSectionName as '执行科室',
a.CDOpenBillName as '开单科室',a.CDTime as '记账时间',a.CDHopitalName as '医院名称',
b.StaffName as '开单医生',c.CFRemarks as '费用类别'
from HJY_ChargeDetailsInfo as a,HJY_StaffInfo as b,HJY_ChargeClassificationInfo as c 
where a.SID = b.SID
and 
a.CDPayServiceName = c.ChargeClassificationName

Answer 1

通过datatable接收到数据库中查询到的数据 然后直接用datasource属性给datagrdview绑定数据即可