Is there anyway to use these parameter things with an UPDATE Sql command or do they only help with Inserts?
Edit: Got it! Turns out I'd got a comma in the wrong place which is why it didn't seem to be working!
(Teach me to code when I should be in bed
)
Anyway, for anyone else with such problems:
Code:
cmd.CommandText = "Update [Table] SET Col1 = @Value1, Col2 = @Value2 WHERE col3 = [whatever]"
works fine, just don't forget to watch the commas!