Own sorting in Infragistics' ultraGrid

My application's user submitted request to add possibility to change way how decimal columns are sorted in grid.

He wanted sort decimals by absolute values.

Turned out it is pretty easy to implement using IComparer interface + grid SortComparer property.

Final effect:

Example code:

<br />ultraGrid1.DisplayLayout.Bands[0].Columns[4].SortComparer = new GridComparerABS();<br />public class GridComparerABS : IComparer {<br />        public int Compare(object x, object y) {<br />            UltraGridCell xCell = (UltraGridCell)x;<br />            UltraGridCell yCell = (UltraGridCell)y;                                    <br />            decimal decX = (decimal) xCell.Value;<br />            decimal decY = (decimal) yCell.Value ;<br />            return decimal.Compare( Math.Abs(decX), Math.Abs( decY ) );<br />        }<br />}<br />

How to set programically Infragistics ultraGrid headers groups

Infragistics ultragrid is very flexible control.

One of nice option is header groups and levels which is not very common knowledge.

Grouped columns look like this:

 

To archieve that the easiest way is use built-in grid's designer.

But if you want to do the same in runtime (set groups programically) you can look at below code snippet:

<br /></P><P>// Create data table<br />DataTable dt = new DataTable();<br />dt.Columns.Add("First Name");<br />dt.Columns.Add("Second Name");<br />dt.Columns.Add("Salary");<br />dt.Columns.Add("Taxes");<br /><br />dt.Rows.Add("Joe","Smith",120000,1000);<br />dt.Rows.Add("Mariah","Carry",1500000,10000);<br /><br /><br />// Bind Datasource<br />ultraGrid1.DataSource = dt;<br /><br /><br />// Create Groups<br />Infragistics.Win.UltraWinGrid.UltraGridGroup group1 = new Infragistics.Win.UltraWinGrid.UltraGridGroup( "Personal Info",1); // key + unique id<br />Infragistics.Win.UltraWinGrid.UltraGridGroup group2 = new Infragistics.Win.UltraWinGrid.UltraGridGroup( "Salary Info",2);            <br /><br />// Add Groups to BAND<br />ultraGrid1.DisplayLayout.Bands[0].Groups.Add( group1 );<br />ultraGrid1.DisplayLayout.Bands[0].Groups.Add( group2 );<br /><br />// *** Assign columns to groups **<br /><br />// option 1 Through gropus Columns<br />group1.Columns.Add( ultraGrid1.DisplayLayout.Bands[0].Columns[0] );<br />group1.Columns.Add( ultraGrid1.DisplayLayout.Bands[0].Columns[1] );<br />group2.Columns.Add( ultraGrid1.DisplayLayout.Bands[0].Columns[2] );<br />group2.Columns.Add( ultraGrid1.DisplayLayout.Bands[0].Columns[3] );<br /><br />// option 2 Columns group<br />//ultraGrid1.DisplayLayout.Bands[0].Columns[0] .Group = group1;<br /> </P><br />