How to reorder SFDataGrid Columns

[Carlos Ferreira]

Hello,

I've created an UnboundColumn in my SFDataGrid.

It load correctly and displays data correctly.

But, it load as the first column in my datagrid.

How do I reorder it to show as last column in datagrid?

This is my UnboundColumn...

GridUnboundColumn column = new GridUnboundColumn

            {

                CaseSensitive = false,

                AllowEditing = false,

                MappingName = "Days",

                HeaderText = "Days",

                Expression = userInfo.GetDias.ToString(),

                CellStyle = new CellStyleInfo() { BackColor = Color.LightGray, TextColor = Color.DarkBlue, HorizontalAlignment = HorizontalAlignment.Right }

            };

            data.Columns.Add(column);

Thanks.

[Arulraj A]

Hi Carlos, 

 

Thanks for contacting Syncfusion support. 

   

If you want to add the GridUnboundColumn as a last column, you have to add the GridUnboundColumn after setting the SfDataGrid.DataSource while enabling the SfDataGrid.AutoGenerateColumns. Please refer the below code example, 

 

Code Example 

ProductSalesDetailsCollection data = new ProductSalesDetailsCollection(); 

sfDataGrid.DataSource = data.SalesInfo; 

 

GridUnboundColumn column = new GridUnboundColumn(); 

column.CaseSensitive = false; 

column.AllowEditing = false; 

column.MappingName = "GrandTotal"; 

column.HeaderText = "Grand Total"; 

column.Expression = "Quantity*Amount"; 

column.Format = "{0:C}"; 

sfDataGrid.Columns.Add(column); 

 

Otherwise, after add the GridUnboundColumn you can move the column to the last position. Please refer the below code example 

 

Code Example 

ProductSalesDetailsCollection data = new ProductSalesDetailsCollection(); 

GridUnboundColumn column = new GridUnboundColumn(); 

column.CaseSensitive = false; 

column.AllowEditing = false; 

column.MappingName = "GrandTotal"; 

column.HeaderText = "Grand Total"; 

column.Expression = "Quantity*Amount"; 

column.Format = "{0:C}"; 

sfDataGrid.Columns.Add(column); 

sfDataGrid.DataSource = data.SalesInfo; 

sfDataGrid.Columns.Move(0, sfDataGrid.Columns.Count-1); 

 

Sample Location: http://www.syncfusion.com/downloads/support/forum/139306/ze/Reorder_Columns2011964131.zip 

 

Regards, 

Arulraj A 

[Carlos Ferreira]

Thanks. That worked!

[Arulraj A]

Hi Carlos, 

We are glad to know that the reported problem has been resolved. Please let us know if you need any further assistance on this. 

We are happy to help you. 

Regards, 

Arulraj A