Using Datatables in memory.

Question

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.

Andrzej Wegierski · Answer

If Your file is anywhere on disk try to use .net text SQL interface as in www.connectionstrings.com to read it. Some sql commands You can use in DataTable.Select() method but it works slow.

tom · Answer

PS. the tables and all operations occur in memory. not on a sql server or anything physical