DataTable supports the Find()
methods for quick searching. But a faster way is to use a DataView with a sort column.
DataView generates an index for a sorted column. If you're searching for data using a particular column, create a DataView sorted by the column you need to search. Then, use the Dataview.FindRows() method to get the data. The DataView will have created an index for the sort column, and FindRows() will use the index.