1. Feedback
  2. Blazor
  3. 12495

Welcome to the Blazor feedback portal. We’re happy you’re here! If you have feedback on how to improve the Blazor, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

1
Vote

Blazor DataGrid Custom Adpater bug when updating last row in datasource

When updating the last row of a datasource in a datagrid using a custom adapter, the grid appears to get stuck and not show the updated data even though it is saved in the database fine.  Clicking a header to filter forces the grid to refresh.  This only happens on the last row of data as any other row update works fine and refreshes the rows new data.  The edit buttons in the header menu also remain as Update / Cancel in this instance and stop working.  No console exceptions are thrown.


Here is my custom adapter and page code to hopefully help:

@code { 

 public EjsGrid CurrencyGrid; 

 public EjsToast ToastObj; 

 public async Task ActionFailureHandler(Syncfusion.EJ2.Blazor.Grids.FailureEventArgs args) 

 { // Show error and refresh the grid 

            if (args.Error != null) { await ToastObj.Show(new ToastModel() { Title = "Error", Content = args.Error.ToString(), CssClass = "e-toast-danger" }); 

 CurrencyGrid.Refresh(); 

 await InvokeAsync(StateHasChanged); 

 } 

 }




public class CurrencyAdaptor : DataAdaptor

    {

        private ApplicationDbContext _dbcontext;

        private IQueryable _dataSource;

        //Provide parameter for constructor

        public CurrencyAdaptor(ApplicationDbContext context)

        {

            _dbcontext = context;

            _dataSource = _dbcontext.Set();

        }


        // Performs data Read operation

        public override object Read(DataManagerRequest dm, string key = null)

        {


            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 = _dataSource.Count();


            if (dm.Skip != 0)

            {

                //Paging

                _dataSource = DataOperations.PerformSkip(_dataSource, dm.Skip);

            }


            if (dm.Take != 0)

            {

                _dataSource = DataOperations.PerformTake(_dataSource, dm.Take);

            }


            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)

        {


            var data = _dataSource.Where(e => e.Id == (value as Currency).Id).FirstOrDefault();


            if (data != null)

            {

                data.Name = (value as Currency).Name;

                data.AlphaCode = (value as Currency).AlphaCode;

                data.NumericCode = (value as Currency).NumericCode;

                data.MinorUnit = (value as Currency).MinorUnit;


               

                try

                {

                    _dbcontext.SaveChanges();

                }

                catch (DbUpdateException ex)

                {

                    ex.Entries.Single().Reload();                    

                    throw ex;

                }


            }


            return data;


        }


        public override object Insert(DataManager dataManager, object value, string key)

        {


            _dbcontext.Add((value as Currency));

            _dbcontext.SaveChanges();


            return value;

        }

    }