Fog Creek Software
Discussion Board




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.

Richard Kuo
Wednesday, October 29, 2003

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).

Duncan Smart
Thursday, October 30, 2003

*  Recent Topics

*  Fog Creek Home