Dear Support,
I am using radzen datagrid and would like to know how does it manage keyset pagination ?
My scenario is that I am on page 5 seeing 50-60 rows and then someone deletes 10 rows 40-50 then when I navigate to previous page I see same 50-60 rows as they gone to 40-50 since I was using skip and take.
I have studied online that I need to use keyset pagination but not sure how that fits in Radzen DataGrid if you could please advise ?
The DataGrid doesn't implement keyset pagination out of the box — LoadData gives you Skip and Top and the grid never executes the query itself; it only expects you to set Data (the current page) and Count (the total). How you produce that page is entirely up to you, so you can translate page navigation into keyset queries in your own code.
Thank you @enchev.
Can you please advise if you have an example code or anything in your samples to showcase ?
We don’t have any example code. Since this is not something Radzen specific you can look for example code in other forums and sources.