The Expression Editor supports integration with FlexGrid control. Expression Editor, when integrated with grid, enables using expressions on grid and perform operations such as filtering, grouping, sorting, and column calculation over its data. 

To integrate Expression Editor with the FlexGrid, you need to use DataSource property of C1FlexGrid class that gets a collection of objects to generate grid data. Once the grid is populated, data source of Expression editor can be bound to data source of FlexGrid using the DataSource property of C1ExpressionEditor class.

The following image exhibits Expression Editor integrated with FlexGrid control.

The following code demonstrates integrating FlexGrid with Expression Editor. 

C1FlexGrid _flexGrid;
C1ExpressionEditor _expEditor;
C1ExpressionEditorPanel _expPanel;
        
DataView _dvProducts;
DataSet _ds;
        
public Form1()
{            
    InitializeComponent();
    GetDataSource();
    _flexGrid = new C1FlexGrid();
    _expEditor= new C1ExpressionEditor();
    _expEditor.Dock = DockStyle.Fill;
    _expEditor.ExpressionChanged += _expEditor_ExpressionChanged;
    _expPanel = new C1ExpressionEditorPanel();
    _expPanel.Dock = DockStyle.Fill;
    _expPanel.BringToFront();
    _expPanel.ExpressionEditor = _expEditor;
    _flexGrid.Dock = DockStyle.Fill;
    pnlFlexGrid.Controls.Add(_flexGrid);
    grpEditor.Controls.Add(_expEditor);
    grpExpPanel.Controls.Add(_expPanel);            
    _dvProducts = _ds.Tables["Product"].DefaultView;
    _flexGrid.DataSource = _dvProducts;
    _expEditor.DataSource = _ds.Tables[0];

Following topic discuss column calculation on flexGrid using expressions. However, to understand how expression editor helps in filtering, sorting, and grouping refer product sample accompanying the installer and the blog.

Back to Top