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
Post a Comment