I need a procedure for a web application that when called queries a database for fieldx = 0 and then reads the resulting dataset one line at a time into another set of variables, which are then submitted one at a time into another process. Language is C# / ASP.net
1st procedure pull sql data from OrdersDB with fieldx=0
2nd read 1 line of resulting data into set of variables
3rd call 3rd party procedure which uses these variables
4th on success of "3" mark record in original database (call it OrdersDB) fieldx = 1
loop to 2nd step to read another line
repeat until all records read.
on completion give success back to page that called it.