How can 'Group By' on a ultrawingrid column?

c# infragistics
Sunscreen picture Sunscreen · May 26, 2011 · Viewed 11.3k times · Source

On the control appears a feature saying 'Drag a column header to gorup by that column'. Can i do that programmatically. Are there any properties or do I need to embed SQL statements?

Thanks, Sun

Answer

Sebastian Piu picture Sebastian Piu · May 26, 2011

You need to add the column to the SortedColumns collection in the band:

    private void SwitchGroupByFor(string key) //key stands for the ultragridcolumn key
    {
        var band = grid.DisplayLayout.Bands[0];
        var sortedColumns = band.SortedColumns;

        sortedColumns.Add(key, false, true); //last flag indicates is a group by column
    }

hth

Related questions

GIF Animation not working in Windows Form

I have 2 WinForms Form2 uses Infragistics ultraTabControl. On Tab Changing im Showing Form1. In Form1 I have a PictureBox assigned with animated GIF In Form2 I am displaying Form1 like this. Form1 frmOne=new Form1(); frmOne.Show(); Problem GIF is …

Read More
Infragistics Ultragrid - Combobox as column

I have a problem with the UltraGrid control from Infragistics. I have created a ultracombobox with a few values in it: UltraCombo ultraComboPaneel = new UltraCombo(); ultraComboPaneel.DataSource = articleList; ultraComboPaneel.ValueMember = "ArticleID"; ultraComboPaneel.DisplayMember = "Name"; Now I have an UltraGrid, and …

Read More
Which event raise on cell value change in Infragistics UltraGrid?

I am using Infragistics UltraGrid in a Windows Forms application. I need an event which is raised on cell value change. I've tried many events like AfterCellActivate, AfterCellUpdate but was unable to find the right one.

Read More