>I have used the Select method of the DataTable object (for which you need to provide a criteria) in situation like this and it was sometime faster then having to go back to the database.
Well, it sure is. In my case, this is exactly what I need. I select all the records at once. And, then, from that small subset, which should be the case here as it is still relatively small, I can then do it at the memory level. I will look at that route. Thanks