How do I update multiple records in a table in ASP using loops ?
For example.
I have a table with the following colums
ID | Col1 | Col2
-------------------------
1 | 50 | 100
2 | 25 | 130
3 | 55 | 70
I want to add 66 and 77 into the ID # 1 and ID # 3 respectively. So the result should be
ID | Col1 | Col2
-------------------------
1 | 116 | 177
2 | 25 | 130
3 | 121 | 147
Note: All datatype of the colums are integer