Update Multiple Records

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

 

here is a code

I guess this is what you needed

 

Thanx for the reply


that helped