update each recordset with datareader

Posted by knittl on Stack Overflow See other posts from Stack Overflow or by knittl
Published on 2010-04-26T15:05:46Z Indexed on 2010/04/26 15:13 UTC
Read the original article Hit count: 222

Filed under:
|
|

hi,

my situation is the following: i have a datareader and loop over all records returned by a select statement and then call a function with a value from that row. but now i need to update a column in each row, after the function has been called.

using a separate update statement seems like a huge overkill. what's the best method to do so? i've heard about dataadapters and datasets—but the only thing i know is that they exist, not how to use them (properly) in this case.

platform is c# with sql server

© Stack Overflow or respective owner

Related posts about c#

Related posts about sql