Searching in a DataTable

[paulv]

For entering test-data in a 5250 TerminalEmulator screen, I'm reading data from a dataTable ... with about 800 records per customer-code !

Is there a way to filter a DataTable narrowing down the result to e.g. all order-records of order-type 'xx' for one specific customer ?
Or is there a really fast search-option instead of reading the records one-by-one until you find the one that you're looking for ?

[Ankur]

nice question...have you tried exploring excel automation model? I am sure you will get something like "filter by" and "sort by" kind of thing through which you can reach your records faster.