Show and Hide Columns

  • 2 min to read

In Code

To hide a column from the GridControl, set the BaseColumn.Visible property to false. To hide column from the Column Chooser, set the column's ColumnBase.ShowInColumnChooser property to false.

<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:

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

Use the GridControl.Columns property to get all the GridControl's columns (visible and hidden). Use the GridViewBase.VisibleColumns property to get visible columns. You can access individual columns and bands by a 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.

API Description
DataViewBase.ShowColumnChooser Shows the Column Chooser. After you showed the Column Chooser, the GridControl rises the DataViewBase.ShownColumnChooser event.
DataViewBase.HideColumnChooser Hides the Column Chooser. After you hid the Column Chooser, the GridControl rises the DataViewBase.HiddenColumnChooser event.
DataViewBase.IsColumnChooserVisible Gets or sets whether the Column Chooser is visible.
DataViewBase.ColumnChooserTemplate A template that defines the Column Chooser's presentation.
ColumnBase.ColumnChooserHeaderCaption A caption of the column's header displayed in the Column Chooser.
DataViewBase.ColumnChooserColumns A list of columns displayed in the Column Chooser.
DataViewBase.ColumnChooserColumnDisplayMode The Column Chooser's display mode (ShowAllColumns, ShowHiddenColumnsOnly).
TableView.ShowBandsInCustomizationForm Shows the Bands tab in the Column Chooser (in the ShowHiddenColumnsOnly mode).

Customization