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 i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members