How do I manage large data tables?

Question

For reasons that don't make much sense (Read: Not my solution) I need to save a large number of rows, about ~ 90,000, in a DataTable, and I have no way to use a database.

I need to be able to efficiently search for a DataTable to find rows that match some basic criteria. For example, I could look at a row that has a value of 2 in two specific columns.

What is the best way to do this?

Edit: See http://chat.stackoverflow.com/transcript/message/62648#62648 for details ; after I work on this, I will try to summarize the additional details from the chat here, as well as provide my solution.

Answer 1

The solution I ended up using for this excruciatingly inconvenient and inconvenient situation was to use DataTable.Select (), populate a new DataTable, and then use the same operation to select the rows that I need from the refined DataTable.

I think this solution is awkward, but again the limitations on the problem were somewhat unrealistic since I was also on a tight schedule.

Answer 2

You can easily use DataTable.Select()