@page "/test"
@using Syncfusion.Blazor.Grids
@using System.Dynamic;

<SfGrid DataSource="@Orders" AllowFiltering="true" Toolbar="ToolbarItems">
    <GridFilterSettings Type="Syncfusion.Blazor.Grids.FilterType.Excel"></GridFilterSettings>
    <GridColumns>
        <GridColumn Field="OrderID" HeaderText="Order ID" Type="Syncfusion.Blazor.Grids.ColumnType.String"></GridColumn>
        <GridColumn Field="CustomerID" HeaderText="Customer ID" Type="Syncfusion.Blazor.Grids.ColumnType.String"></GridColumn>
        <GridColumn Field="Freight" HeaderText="Freight" Type="Syncfusion.Blazor.Grids.ColumnType.Integer"></GridColumn>
        <GridColumn Field="OrderDate" HeaderText="Order Date" Type="Syncfusion.Blazor.Grids.ColumnType.DateTime"></GridColumn>
    </GridColumns>
</SfGrid>

@code {
    public List<string> ToolbarItems = new List<string>() { "Search" };
    public List<DynamicDictionary> Orders = new List<DynamicDictionary>() { };
    protected override void OnInitialized()
    {
        Orders = Enumerable.Range(1, 20).Select((x) =>
        {
            dynamic d = new DynamicDictionary();
            d.OrderID = 1000 + x;
            d.CustomerID = (new string[] { "ALFKI", "ANANTR", "ANTON", "BLONP", "BOLID" })[new Random().Next(5)];
            d.Freight = 1 + x;
            d.OrderDate = DateTime.Now.AddDays(-x);
            return d;
        }).Cast<DynamicDictionary>().ToList<DynamicDictionary>();

        // Additional record to set Freight = null and consider Freight column as nullable int
        dynamic d = new DynamicDictionary();
        d.OrderID = 1021;
        d.CustomerID = (new string[] { "ALFKI", "ANANTR", "ANTON", "BLONP", "BOLID" })[new Random().Next(5)];
        d.Freight = null;
        d.OrderDate = DateTime.Now.AddDays(-21);

        Orders.Add(d);
    }
    public class DynamicDictionary : DynamicObject
    {
        Dictionary<string, object> dictionary = new Dictionary<string, object>();

        public override bool TryGetMember(GetMemberBinder binder, out object result)
        {
            string name = binder.Name;
            return dictionary.TryGetValue(name, out result);
        }
        public override bool TrySetMember(SetMemberBinder binder, object value)
        {
            dictionary[binder.Name] = value;
            return true;
        }

        public override System.Collections.Generic.IEnumerable<string> GetDynamicMemberNames()
        {
            return this.dictionary?.Keys;
        }
    }
}