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
State of Florida, DCF