hi

Lets say in a situation where i need to load all the records in a table which is estimate to be around 1,000,000 records excluding linkage to other table

what is the best way to load all the data into the listview?

if have thought of a few ways like selecting all the records and download into a datatable, but using this way will only kill the client machine.

Does anyone knows or suggest a better way to handle this kind of situation?


Thanks!!