Hi--
I use a very strict naming convention that helped efficiency quite a bit in VB6. If I had a form that enabled changed to 50 records, I would use an update code that would go something like

For I = 1 to #records
"Update [tablename] Set [blah] = Me("txtparam" & I).Text [...] where [column1] = " & Me("txt" & I).Text
Next

It allowed me to update a great many records without writing a ton of sql statements
(it would read out, for the [column1] example: "txt1" "txt2" etc)

how do I accomplish this in vb.net?