GridControl页脚显示列的汇总数据

关键属性:
gridView4.OptionsView.ShowFooter = true;//启用显示页脚 //索引为1的列 gridView4.Columns[1].SummaryItem.DisplayFormat = "{0:0.##}"; gridView4.Columns[1].SummaryItem.FieldName = "TotalMoney"; gridView4.Columns[1].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;//求和 //索引为2的列 gridView4.Columns[2].SummaryItem.DisplayFormat = "{0:0.##}"; gridView4.Columns[2].SummaryItem.FieldName = "PayTotalMoney"; gridView4.Columns[2].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;//求和 //索引为3的列 gridView4.Columns[3].SummaryItem.DisplayFormat = "{0:0.##}"; gridView4.Columns[3].SummaryItem.FieldName = "UnPayMoney"; gridView4.Columns[3].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;//求和 gridView4.CustomDrawFooterCell += new FooterCellCustomDrawEventHandler(this.gridView4_CustomDrawFooterCell);//设置一下对齐方式,通过GridView的CustomDrawFooterCell 事件

给页脚加数据汇总

 

posted @ 2020-07-27 16:32  宇宙无敌狗蛋  阅读(444)  评论(0编辑  收藏  举报