Handling large dataset

Question

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