I'll check into that.

Richard


>>I am importing a text file (20 - 50,000 records) that gets FTP'ed down from a mainframe into a DataTable. Now, before I update the database with this data, I need to summarize it a bit.
>>
>>In VFP, I would do this:
>>
>>

>>Select Field1, Field2, sum(Amount) as newamount
>>from mycursor
>>into cursor tmpCursor
>>group by Field1, Field2
>>

>>
>>then do some other stuff that is more readily apparent.
>>
>>How can I mimic the above in .NET without sending the entire thing up to a temporary file on the server performing the action there then requesting it back into a DataTable?
>>
>>Any suggestions?
>>
>>Thanks
>>
>>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