Welcome! and rules
Joel on Software
Updating large datasets in ADO.NET?
Maybe it's that I don't really know where to start on this, but what is the recommended way to walk over a very large dataset updating/changing certain fields? I can't really seem to find a forward only cursor type of object similar to the DataReader. I also can't load the whole dataset into memory since the number of rows is huge.
There are no read/write cursors in .NET. Are many people going to be doing this at once? If not: use a DataReader on one connection to walk through the data, then open another connection and issue the UPDATES on that (using SqlCommand.ExecuteNonQuery or whatever).
Fog Creek Home