Search code examples
c#devexpress

DevExpress How to get sum of GridView column's C#


I try to get summary of gridView column's and pass it to textEdit, I try this code:

textedit1.text= Convert.ToInt32(gridView1.Columns[1].SummaryItem.SummaryValue).ToString();

but always I get 0 value Can any one help me?


Solution

  • I solve it by set SummaryType to sum and it works as a charm.

    gridview1.Columns["salary"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
    

    Or from the designer, select gridControl, quick menu, Run Designer: Columns, Select the required column, from its properties select SummaryItem and change SummaryType to sum.