I have a large collection in sql database. when I use DataSet, I assume that all the time (and when I say everything, I mean 20,000+) database entries to populate the scrollable view of the WPF list. when I extract so much data and add more data, I run out of memory.
I asked a similar question: a program that uses all the memory from the sql listview table, how to fill only the relevant data? , and I need to use it with a list view.
how can i extract the data i need when the user scrolls? will DataReadwork here? I saw DataRead tutorials, but they are usually button-based, and I need to read the data dynamically based on the direction the user scrolls the list.
Is there a way to do this update based on, say, 30 values, if the user sees 15 of them, then the lag between the server request and the returned value will not cause any problems in the list view The user scrolls up or down?
source
share