Handling large dataset

Hi,

i have two questions.

1. what is the best method to retrive large table from sql server

2. what is the best method to handling large dataset e.g searching and sorting in c# not in databse level

Thanks

Wilson

Eric Heinze
This is a loaded question that neeeds some context. Can you answer a few questions.
1. Are you doing WinForm or ASP.NET development
2. Are you going to hold on to the data or use it once and throw it away
3. How large are your datasets
tank959
1. I am working for web project.

2. I hold the data during the life of web application.

3. it is around 100k records.
humble.apprentice
Anyone can give me some suggestion
Handling large dataset