Using DateRangePicker with Grid

[Nick]

I am using a DateRangePicker control along with a Grid using this example https://www.syncfusion.com/forums/159831/blazor-how-to-export-pdf-according-to-range-of-date-like-date-start-to-date-end but when I clear the date range value, it clears out the Grid. Is there anyway for me to reload the Grid in that scenario?

[Monisha Saravanan]

Hi Nick,

Greetings from Syncfusion support.

We have checked your reported query and we suggest you to overcome the reported issue by assigning an new query when the value is cleared in the DateRangePicker. Kindly check the attached sample and code snippet for your reference.

<SfDateRangePicker @ref="DatePicker" Placeholder="Choose a Range">

    <DateRangePickerEvents ValueChange="OnChange"></DateRangePickerEvents>

</SfDateRangePicker>

 

<SfButton OnClick="PdfExport" Content="Pdf Export"></SfButton>

<SfGrid @ref="DefaultGrid" DataSource="@Orders" Query="@Qry" AllowPdfExport="true" AllowPaging="true">

    <GridColumns>

     

    </GridColumns>

</SfGrid>

 

@code{

    private SfGrid<Order> DefaultGrid;

    public Query Qry = new Query();

    SfDateRangePicker DatePicker { get; set; }

    public List<Order> Orders { get; set; }

    public void OnChange(RangeEventArgs Args)

    {

        if (Args.Value != null)

        {

            var Col1Pre = new WhereFilter();

            var predicate = new List<WhereFilter>();

            predicate.Add(new WhereFilter() { Condition = "or", Field = "OrderDate", value = Args.StartDate, Operator = "greaterthanorequal" });

            predicate.Add(new WhereFilter() { Condition = "or", Field = "OrderDate", value = Args.EndDate, Operator = "lessthanorequal" });

            Col1Pre = WhereFilter.And(predicate);

            Qry = new Query().Where(Col1Pre); // to filter the Grid

        }

        else

        {

            Qry = new Query();

        }

    }

}

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/DataGrid125137208.zip

Kindly get back to us if you have further queries.

Regards,

Monisha.