>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.

What I ended up doing for this was to select all my records in one query and then I apply a DataView.RowFilter to look for what I need. The main goal is to avoid going back querying on the live data. There are many ways to do it. For me, for the related needs, I found the DataView.RowFilter to be quite ok.

Thanks