Member Avatar for cancer10
cancer10 47 Posting Whiz in Training

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

  • 1 Contributor
  • 0 Replies
  • 52 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.