How to make Search fast

Dec 26 2009 8:05 AM
hey..i got a microsoft access db with a table called items which has more than 100,000 records.So in my application when i search for some item it takes some time to give me the result in the data grid.

Basically what i do is add each item object to arraylist and  then return it to print in the datagrid.im new to c# and i wanna knw a bettr method to do my search wher it takes less time ..thanks in advance..

Best regards,
Hussain



Answers (6)