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: 224
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