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
Handling large dataset
Hi,
Adnan HasanPosted May 11, 2006, 7:42 AM
For 1st:
Use Index in the Table
Use Strored Procedure to call the Select queries.
For 2nd:
There are methods present in DataSet/DataTable level to Sort data ans for searching there is method called Select which can be use to get the filtered data from offline dataset/datatables.
Thank You
Adnan Hasan