Fetching million data in dataset for datagrid slow down my system.

[yatharth]

Hi Mike


I have Datagrid and i am fetching data around about 1 million into it ,
i think which is not good deal this makes my system slow.Please tell
the way so that i can fetch data in my dataset or else so that i dont
have to fetch such a large data again and again.


My datagrid alows paging.

 

[W.G. Ryan MVP]

There's NO way you want to fetch 1 million records into a grid. No user can
possible see that much data at once. Also, if you fill a datatable that
already has data, then the new rows will be added. So you can use WHere
whatever between 1 AND 10, then Where whatever between 11 and 20 etc to
simulate paging. 1million rows is a ton of data to be working with and
unless this is batch processing that doesn't have humans using it, there's
probably little reason to ever work with that much data