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