Learn .NET

Aspx gridview control Header Filter

By default, these buttons are hidden. To show filter buttons, set the Settings.ShowHeaderFilterButton property to true.
The ASPxGridView allows you to create custom filter values, define a filter criteria for them and display these values within a column's filter dropdown. To do this, handle the HeaderFilterFillItems event. In this demo, custom filter values are displayed within the 'Total' and 'Quantity' columns' filter dropdowns.
Loading…



TagPrefix and page properties
 <asp:Content ID="Content1" ContentPlaceHolderID="phContent" Runat="Server">
     <dxwgv:ASPxGridView ID="grid" ClientInstanceName="grid" runat="server" DataSourceID="AccessDataSource1" KeyFieldName="OrderID"
         OnCustomUnboundColumnData="grid_CustomUnboundColumnData" Width="100%" AutoGenerateColumns="False" OnHeaderFilterFillItems="grid_HeaderFilterFillItems">
         <Columns>

Expand Auto Generated Columns

             <dxwgv:GridViewDataTextColumn FieldName="UnitPrice" VisibleIndex="4">
                 <PropertiesTextEdit DisplayFormatString="c">
                 </PropertiesTextEdit>
             </dxwgv:GridViewDataTextColumn>
             <dxwgv:GridViewDataTextColumn FieldName="Total" VisibleIndex="6" UnboundType="Decimal">
                 <FooterCellStyle ForeColor="Brown"> </FooterCellStyle>
                 <PropertiesTextEdit DisplayFormatString="c">
                 </PropertiesTextEdit>
             </dxwgv:GridViewDataTextColumn>
         </Columns>
         <Settings ShowGroupPanel="True" ShowFooter="True" ShowHeaderFilterButton="true" />
         <TotalSummary>
             <dxwgv:ASPxSummaryItem FieldName="CompanyName" SummaryType="Count"/>
             <dxwgv:ASPxSummaryItem FieldName="Total" SummaryType="Sum" DisplayFormat="c"/>
             <dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Min" />
             <dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Average" />
             <dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Max" />
         </TotalSummary>
     </dxwgv:ASPxGridView>

Expand DataSource

 </asp:Content>TagPrefix and page properties
 <asp:Content ID="Content1" ContentPlaceHolderID="phContent" Runat="Server">
     <dxwgv:ASPxGridView ID="grid" ClientInstanceName="grid" runat="server" DataSourceID="AccessDataSource1" KeyFieldName="OrderID"
         OnCustomUnboundColumnData="grid_CustomUnboundColumnData" Width="100%" AutoGenerateColumns="False" OnHeaderFilterFillItems="grid_HeaderFilterFillItems">
         <Columns>

Expand Auto Generated Columns

             <dxwgv:GridViewDataTextColumn FieldName="UnitPrice" VisibleIndex="4">
                 <PropertiesTextEdit DisplayFormatString="c">
                 </PropertiesTextEdit>
             </dxwgv:GridViewDataTextColumn>
             <dxwgv:GridViewDataTextColumn FieldName="Total" VisibleIndex="6" UnboundType="Decimal">
                 <FooterCellStyle ForeColor="Brown"> </FooterCellStyle>
                 <PropertiesTextEdit DisplayFormatString="c">
                 </PropertiesTextEdit>
             </dxwgv:GridViewDataTextColumn>
         </Columns>
         <Settings ShowGroupPanel="True" ShowFooter="True" ShowHeaderFilterButton="true" />
         <TotalSummary>
             <dxwgv:ASPxSummaryItem FieldName="CompanyName" SummaryType="Count"/>
             <dxwgv:ASPxSummaryItem FieldName="Total" SummaryType="Sum" DisplayFormat="c"/>
             <dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Min" />
             <dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Average" />
             <dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Max" />
         </TotalSummary>
     </dxwgv:ASPxGridView>

Expand DataSource

 </asp:Content>TagPrefix and page properties
 <asp:Content ID="Content1" ContentPlaceHolderID="phContent" Runat="Server">
     <dxwgv:ASPxGridView ID="grid" ClientInstanceName="grid" runat="server" DataSourceID="AccessDataSource1" KeyFieldName="OrderID"
         OnCustomUnboundColumnData="grid_CustomUnboundColumnData" Width="100%" AutoGenerateColumns="False" OnHeaderFilterFillItems="grid_HeaderFilterFillItems">
         <Columns>

Expand Auto Generated Columns

             <dxwgv:GridViewDataTextColumn FieldName="UnitPrice" VisibleIndex="4">
                 <PropertiesTextEdit DisplayFormatString="c">
                 </PropertiesTextEdit>
             </dxwgv:GridViewDataTextColumn>
             <dxwgv:GridViewDataTextColumn FieldName="Total" VisibleIndex="6" UnboundType="Decimal">
                 <FooterCellStyle ForeColor="Brown"> </FooterCellStyle>
                 <PropertiesTextEdit DisplayFormatString="c">
                 </PropertiesTextEdit>
             </dxwgv:GridViewDataTextColumn>
         </Columns>
         <Settings ShowGroupPanel="True" ShowFooter="True" ShowHeaderFilterButton="true" />
         <TotalSummary>
             <dxwgv:ASPxSummaryItem FieldName="CompanyName" SummaryType="Count"/>
             <dxwgv:ASPxSummaryItem FieldName="Total" SummaryType="Sum" DisplayFormat="c"/>
             <dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Min" />
             <dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Average" />
             <dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Max" />
         </TotalSummary>
     </dxwgv:ASPxGridView>

Expand DataSource

 </asp:Content>TagPrefix and page properties
 <asp:Content ID="Content1" ContentPlaceHolderID="phContent" Runat="Server">
     <dxwgv:ASPxGridView ID="grid" ClientInstanceName="grid" runat="server" DataSourceID="AccessDataSource1" KeyFieldName="OrderID"
         OnCustomUnboundColumnData="grid_CustomUnboundColumnData" Width="100%" AutoGenerateColumns="False" OnHeaderFilterFillItems="grid_HeaderFilterFillItems">
         <Columns>

Expand Auto Generated Columns

             <dxwgv:GridViewDataTextColumn FieldName="UnitPrice" VisibleIndex="4">
                 <PropertiesTextEdit DisplayFormatString="c">
                 </PropertiesTextEdit>
             </dxwgv:GridViewDataTextColumn>
             <dxwgv:GridViewDataTextColumn FieldName="Total" VisibleIndex="6" UnboundType="Decimal">
                 <FooterCellStyle ForeColor="Brown"> </FooterCellStyle>
                 <PropertiesTextEdit DisplayFormatString="c">
                 </PropertiesTextEdit>
             </dxwgv:GridViewDataTextColumn>
         </Columns>
         <Settings ShowGroupPanel="True" ShowFooter="True" ShowHeaderFilterButton="true" />
         <TotalSummary>
             <dxwgv:ASPxSummaryItem FieldName="CompanyName" SummaryType="Count"/>
             <dxwgv:ASPxSummaryItem FieldName="Total" SummaryType="Sum" DisplayFormat="c"/>
             <dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Min" />
             <dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Average" />
             <dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Max" />
         </TotalSummary>
     </dxwgv:ASPxGridView>

Expand DataSource

 </asp:Content>TagPrefix and page properties
 <asp:Content ID="Content1" ContentPlaceHolderID="phContent" Runat="Server">
     <dxwgv:ASPxGridView ID="grid" ClientInstanceName="grid" runat="server" DataSourceID="AccessDataSource1" KeyFieldName="OrderID"
         OnCustomUnboundColumnData="grid_CustomUnboundColumnData" Width="100%" AutoGenerateColumns="False" OnHeaderFilterFillItems="grid_HeaderFilterFillItems">
         <Columns>

Expand Auto Generated Columns

             <dxwgv:GridViewDataTextColumn FieldName="UnitPrice" VisibleIndex="4">
                 <PropertiesTextEdit DisplayFormatString="c">
                 </PropertiesTextEdit>
             </dxwgv:GridViewDataTextColumn>
             <dxwgv:GridViewDataTextColumn FieldName="Total" VisibleIndex="6" UnboundType="Decimal">
                 <FooterCellStyle ForeColor="Brown"> </FooterCellStyle>
                 <PropertiesTextEdit DisplayFormatString="c">
                 </PropertiesTextEdit>
             </dxwgv:GridViewDataTextColumn>
         </Columns>
         <Settings ShowGroupPanel="True" ShowFooter="True" ShowHeaderFilterButton="true" />
         <TotalSummary>
             <dxwgv:ASPxSummaryItem FieldName="CompanyName" SummaryType="Count"/>
             <dxwgv:ASPxSummaryItem FieldName="Total" SummaryType="Sum" DisplayFormat="c"/>
             <dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Min" />
             <dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Average" />
             <dxwgv:ASPxSummaryItem FieldName="Quantity" SummaryType="Max" />
         </TotalSummary>
     </dxwgv:ASPxGridView>

Expand DataSource

 </asp:Content>
Ebook Download
View all
Learn
View all
Get Started

You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.

Become a sharper developer and jumpstart your career.

Basic

$0

$

. 00

monthly

For Basic members:

  • Standard Profile
  • Access learning courses
  • Access free e-books
  • 1x point
Premium

$20

$

. 00

monthly

For Premium members:

  • Earn 2x reward points
  • Premium profile with Verified check
  • Premium Avatar with status update
  • Learning courses
  • Unlimited Certifications and badges on profile
  • Unlimited Book downloads
  • Access to Premium content
  • Online Training
  • Unlimited PDF conversions and downloads
  • Professional Resume Writing
  • Interview Preparations Guide
  • 25 messages per month
  • 1 "Kodzu" avatar, basic
Elite

$45

$

. 00

monthly

For Elite members:

  • Bundle E-books
  • Access to all Learn Series
  • Unlimited Apply Jobs