Using Datatables in memory.

I am reading in a text file and have placed it into a datatable one row at a time. I can filter some rows i do not want on the row.add operations, and can get a dataview based on a rowfilter method. Would like to use SQL commands since I dont think rowfilter is that strong or maybe i dont have a good reference for it. Any suggestions? Thanks.