>I'll check into that.
>
>Richard
>
>
>>
>>You can use Sql Server CE and a local DB instead of DataTable, then you can do whatever you want using SQL and SqlCeResultSet

I've done some tests, seems that loading data into SqlServerCE database table is 5-6 times faster than loading into a ADO.NET datatable.