update churned rows sql table


suppose there entirely populated array information string[n][3] mydata.



i wish this:



for (string[] quarrel : mydata)
{
sql = "update mytable set col3 = row[2]
where col1 = row[0] col2=row[1];"
}


obviously i've left lot out, nonetheless i wish demonstrate thought succinctly possible.



is there rudimentary proceed doing unparalleled db command?
how rudimentary way?



edits:
data opening another list (it's web form defeat - churned choice exam)

seeing app web facing, it's got injection proof. parameterized queries comparison proceed going.

i'm controlling ms-sql server 2005



edit:closing, re-asking



edit: re-opened, appears renouned question



Comments

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?