DataGrid LoadData

The LoadData event allows you to perform custom paging, sorting and filtering.

To perform custom data-binding:

1. Set the Data and Count properties.

   <RadzenDataGrid Count="@count" Data="@employees"

2. Handle the LoadData event and update the Data and Count backing fields (employees and count in this case).

   
   void LoadData(LoadDataArgs args)
   {
       var query = dbContext.Employees.AsQueryable();
   
       if (!string.IsNullOrEmpty(args.Filter))
       {
           query = query.Where(args.Filter);
       }
   
       if (!string.IsNullOrEmpty(args.OrderBy))
       {
           query = query.OrderBy(args.OrderBy);
       }
   
       employees = query.Skip(args.Skip.Value).Take(args.Top.Value).ToList();
   
       count = dbContext.Employees.Count();
   }