OBOUT - ASP.NET Grid - Date Filters

Quick Links

ASP.NET Grid - Date Filters

ORDER ID

NAME

ORDER DATE

SHIPPED DATE

REQUIRED DATE


11067	Drachenblut Delikatessen	5/4/1998 5/4/1998 12:00:00 AM	5/6/1998 5/6/1998 12:00:00 AM	5/18/1998 5/18/1998 12:00:00 AM
11066	White Clover Markets	5/1/1998 5/1/1998 12:00:00 AM	5/4/1998 5/4/1998 12:00:00 AM	5/29/1998 5/29/1998 12:00:00 AM
11064	Save-a-lot Markets	5/1/1998 5/1/1998 12:00:00 AM	5/4/1998 5/4/1998 12:00:00 AM	5/29/1998 5/29/1998 12:00:00 AM
11063	Hungry Owl All-Night Grocers	4/30/1998 4/30/1998 12:00:00 AM	5/6/1998 5/6/1998 12:00:00 AM	5/28/1998 5/28/1998 12:00:00 AM
11060	Franchi S.p.A.	4/30/1998 4/30/1998 12:00:00 AM	5/4/1998 5/4/1998 12:00:00 AM	5/28/1998 5/28/1998 12:00:00 AM
11057	North/South	4/29/1998 4/29/1998 12:00:00 AM	5/1/1998 5/1/1998 12:00:00 AM	5/27/1998 5/27/1998 12:00:00 AM
11056	Eastern Connection	4/28/1998 4/28/1998 12:00:00 AM	5/1/1998 5/1/1998 12:00:00 AM	5/12/1998 5/12/1998 12:00:00 AM
11055	HILARION-Abastos	4/28/1998 4/28/1998 12:00:00 AM	5/5/1998 5/5/1998 12:00:00 AM	5/26/1998 5/26/1998 12:00:00 AM
11052	Hanari Carnes	4/27/1998 4/27/1998 12:00:00 AM	5/1/1998 5/1/1998 12:00:00 AM	5/25/1998 5/25/1998 12:00:00 AM
11050	Folk och fä HB	4/27/1998 4/27/1998 12:00:00 AM	5/5/1998 5/5/1998 12:00:00 AM	5/25/1998 5/25/1998 12:00:00 AM

1 - 10 of 15 - Pages:

Apply Filter | Hide Filter | Remove Filter

StartDate_OrderDate,EndDate_OrderDate

value,value

Year_OrderDate

value

Month_OrderDate

value

YearMonth_Year_OrderDate,YearMonth_Month_OrderDate

value,value

StartDate_ShippedDate,EndDate_ShippedDate

value,value

Year_ShippedDate

value

Month_ShippedDate

value

YearMonth_Year_ShippedDate,YearMonth_Month_ShippedDate

value,value

StartDate_RequiredDate,EndDate_RequiredDate

value,value

Year_RequiredDate

value

Month_RequiredDate

value

YearMonth_Year_RequiredDate,YearMonth_Month_RequiredDate

value,value

The CustomFilterOption class allows you to create new filter options that are more advanced than the standard ones offered by the Grid. Each custom option may have a template applied to it and you can have a different template for each custom filter option.

You can use the OnFiltering server-side event to generate the appropriate filter expressions for each column, based on the values of the fields from the filter options templates.

In this example we have created four custom filter options for each date column.

ASP.NET

<obout:Column runat="server" DataFormatString="{0:M/d/yyyy}" DataField="OrderDate">
    <FilterOptions>
        <obout:CustomFilterOption IsDefault="true" ID="Between_OrderDate" Text="Between">
            <TemplateSettings FilterTemplateId="OrderDateBetweenFilter" 
                FilterControlsIds="StartDate_OrderDate,EndDate_OrderDate"
                FilterControlsPropertyNames="value,value" />
        </obout:CustomFilterOption>
        <obout:CustomFilterOption ID="ByYear_OrderDate" Text="Filter By Year">
            <TemplateSettings FilterTemplateId="OrderDateByYearFilter" 
                FilterControlsIds="Year_OrderDate"
                FilterControlsPropertyNames="value" />
        </obout:CustomFilterOption>
        <obout:CustomFilterOption ID="ByMonth_OrderDate" Text="Filter By Month">
            <TemplateSettings FilterTemplateId="OrderDateByMonthFilter" 
                FilterControlsIds="Month_OrderDate"
                FilterControlsPropertyNames="value" />
        </obout:CustomFilterOption>
        <obout:CustomFilterOption ID="ByYearAndMonth_OrderDate" Text="Filter By Year And Month">
            <TemplateSettings FilterTemplateId="OrderDateByYearAndMonthFilter" 
                FilterControlsIds="YearMonth_Year_OrderDate,YearMonth_Month_OrderDate"
                FilterControlsPropertyNames="value,value" />
        </obout:CustomFilterOption>
    </FilterOptions>
</obout:Column>