Posted on: 4/29/2013 3:52:20 PM | Views : 257

Hi,
     I was asked this question in one interview, I want to share with you all.
If we have more than 50,000 records in our database(suppose Employee table), and we need to show these records on asp.net page, each page would display 100 records with paging. So what is the best approch to implement it, should we use data set to keep all records in data set, should we use Data Reader OR how we can acchive our goal.
Please share your ideas so It will help to others also.
Thanks
VD


...

Go to the complete details ...