Grids in master/slave configuration, slave data always one click behind.

Question

I've set up grids in master/slave configuration, using the master's RowSelected event to change the data for the slave. I'm using a generic custom dataadapter. When I first run the program, the master and slave are in sync. But when I click on the next row of the master, nothing changes in the slave. Then when I click on another row in the master, the slave changes to display the data of the prior selection in the master. In other words, the slave is always one click behind. How do I fix this?Here's my code:Areas.razor:@page "/Lists/Areas"

Areas

@if (areaList == null){

Loading...

}else{

Areas

Showing Rates for Area: @SelectedArea

}@code { SfGrid areaRateGrid; List areaList; List areaRateList; List pumpParameters; public string SelectedArea { get; set; } public Guid? RowIndex { get; set; } protected override async Task OnInitializedAsync() { await Task.Run(() => { areaList = context.Areas.Where(n => n.IsActive == true).ToList(); areaList.Sort(); areaRateList = context.AreaRates.Where(n => n.AreaId == areaList.First().Id).ToList(); areaRateList.Sort(); pumpParameters = context.PumpParameters.ToList(); }); } public void AreaRowSelecthandler(RowSelectEventArgs Args) { SelectedArea = Args.Data.Name; areaRateList = Args.Data.AreaRates; areaRateList.Sort(); areaRateGrid.Refresh(); }}CustomDataAdaptor.razor:@using Newtonsoft.Json@inject IJSRuntime jsRuntime@typeparam T@inherits DataAdaptor @ChildContent@code { [Parameter] public RenderFragment ChildContent { get; set; } [Parameter] public List Details { get; set; } // Performs data Read operation public override object Read(DataManagerRequest dm, string key = null) { IEnumerable DataSource = (IEnumerable)Details; aif (dm.Skip != 0) { //Paging DataSource = DataOperations.PerformSkip(DataSource, dm.Skip); } if (dm.Take != 0) { DataSource = DataOperations.PerformTake(DataSource, dm.Take); } if (dm.Search != null && dm.Search.Count > 0) { // Searching DataSource = DataOperations.PerformSearching(DataSource, dm.Search); } if (dm.Sorted != null && dm.Sorted.Count > 0) { // Sorting DataSource = DataOperations.PerformSorting(DataSource, dm.Sorted); } if (dm.Where != null && dm.Where.Count > 0) { // Filtering DataSource = DataOperations.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator); } int count = Details.Cast().Count(); // return entire record count return dm.RequiresCounts ? new DataResult() { Result = DataSource, Count = count } : (object)DataSource; } // Performs Update operation public override object Update(DataManager dm, object value, string keyField, string key) { return value; }}

Vignesh Natarajan · Accepted Answer

Hi Mike, Thanks for contacting Syncfusion support. Query: “ But when I click on the next row of the master, nothing changes in the slave. In other words, the slave is always one click behind. ” We have analyzed the reported query and we understand that you are facing trouble in updating the slave / detail Grid datasource in Master Grid’s RowSelected event. We are able to reproduce the reported issue at our end also. We found that you have refreshed the Grid component after changing the CustomAdaptor component Details Parameter. But we would like to you that we have rendered the CustomAdaptor as Child component to SfGrid component. So it will be refreshed after refreshing the Grid component. hence the records are updated in one step behind. So we suggest you achieve your requirement by sending the selected record details using Query property of the Grid. In the provided code example, we found that you have filtered the slave Grid record using Id value in parent grid record. So we suggest you to use Where query to filter the records. Refer the below code example.

Areas

Showing Rates for Area: @SelectedArea

@code{ public Query Qry { get; set; } = new Query(); SfGrid areaRateGrid; public List areaList; public List areaRate; public List areaRateList; public string SelectedArea { get; set; } public Guid? RowIndex { get; set; } public void AreaRowSelecthandler(RowSelectEventArgs Args) { Qry = new Query().Where(new WhereFilter() { Field = "CustomerID", Operator = "equal", value = Args.Data.CustomerID }); } protected override void OnInitialized() { areaList = Enumerable.Range(1, 5).Select(x => new Area() { AreaID = 1000 + x, CustomerID = (new string[] { "ALFKI", "ANANTR", "ANTON", "BLONP", "BOLID" })[x - 1], Freight = 2.1 * x, }).ToList(); areaRateList = Enumerable.Range(1, 75).Select(x => new AreaRate() { AreaID = 1000 + x, CustomerID = (new string[] { "ALFKI", "ANANTR", "ANTON", "BLONP", "BOLID" })[new Random().Next(5)], BaseRate = 2.1 * x, }).ToList(); } In above code example, we have filter the CustomerID column with value selected from RowSelected Event. Similarly we suggest you to Filter the corresponding column in slave grid based on the Master Grid Id value. Kindly download the sample which we have prepared using above solution from below Sample: https://www.syncfusion.com/downloads/support/forum/163966/ze/DataGrid-1534768687 Please get back to us if you have further queries or if you are facing difficulties in achieving your requirement. Regards, Vignesh Natarajan

Mike · Answer

Wow, thanks a ton.  I was working on this problem for, well, I won't admit how long.  This solution perfectly solved my problem :)

Vignesh Natarajan · Answer

Hi Mike,  

Thanks for the update.  

We are glad to hear that you have resolved your query using our solution.  

Please get back to us if you have further queries.  

Regards, 
Vignesh Natarajan