How to add Expression columns in Windows Forms GridGroupingControl

15 Jun 20211 minute to read

Expression fields allows you to add a column that holds calculated values based on other fields in the same record. These expression columns can be used in grouping and sorting. This also can be employed as summary fields for summary rows.

  • C#
  • using  Syncfusion.Grouping;
    using  Syncfusion.Windows.Forms.Grid;
    using  Syncfusion.Windows.Forms.Grid.Grouping;
    
    //Declares an ExpressionFieldDescriptor.
    ExpressionFieldDescriptor expression1 = new ExpressionFieldDescriptor();
    expression1.Name = "Sum of all columns";
    
    //Simple expression to add the values in the columns. 
    //For all the valid Expression syntax, refer to the 
    //EssentialGrid UserGuide --> Essential Grid Tutorials ---> 
    //AddsvExpression Fields ---> Valid Expression Syntax 
    expression1.Expression = "[Col0] + [Col1] + [Col2] + [Col3]";
    
    //Adds the Expression column to the grid.
    this.gridGroupingControl1.TableDescriptor.ExpressionFields.Add(expression1);
  • VB
  • Imports Syncfusion.Grouping
    Imports Syncfusion.Windows.Forms.Grid
    Imports Syncfusion.Windows.Forms.Grid.Grouping
    
    'Declares an ExpressionFieldDescriptor.
    Dim expression1 As New ExpressionFieldDescriptor()
    expression1.Name = "Sum of all columns"
    
    'Simple expression to add the values in the columns 
    'For all the valid Expression syntax, refer the 
    'EssentialGrid UserGuide --> Essential Grid Tutorials ---> 
    'Adds Expression Fields ---> Valid Expression Syntax 
    expression1.Expression = "[Col0] + [Col1] + [Col2] + [Col3]"
    
    'Adds the Expression column to the grid.
    Me.gridGroupingControl1.TableDescriptor.ExpressionFields.Add(expression1)