Show and Hide Columns

• Jun 13, 2023
• 2 minutes to read

In Code

Set the BaseColumn.Visible property to false to hide a column or a band from the GridControl. To hide a column or a band from the Column Chooser , set the column’s BaseColumn.ShowInColumnChooser property to false.

• MainWindow.xaml

<dxg:GridControl.Columns>
    <dxg:GridColumn FieldName="Name" IsSmart="True"/>
    <dxg:GridColumn FieldName="City" IsSmart="True">
        ...
    </dxg:GridColumn>
    <dxg:GridColumn FieldName="Visits" IsSmart="True" Visible="False"/>
    <dxg:GridColumn FieldName="Birthday" IsSmart="True" Visible="False" ShowInColumnChooser="False">
        ...
    </dxg:GridColumn>
</dxg:GridControl.Columns>

You can sort data against hidden columns with the GridSortInfo.SortOrder property:

• MainWindow.xaml

<dxg:GridColumn FieldName="Visits" IsSmart="True" SortOrder="Ascending" Visible="False"/>

Use the GridControl.Columns property to get all GridControl columns (visible and hidden). Use the GridViewBase.VisibleColumns property to get visible columns. You can access individual columns and bands by name or index.

Column Chooser

The Column Chooser allows end users to hide and show columns from the GridControl at runtime. Refer to the Show and Hide Columns topic for more information.

Customization

• Customize Column Headers Based on Their Location
• Display a Standalone Column Chooser