1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Update Multiple Records

Discussion in 'C#' started by cancer10, Oct 24, 2006.

  1. #1
    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
     
    cancer10, Oct 24, 2006 IP
  2. ludwig

    ludwig Notable Member

    Messages:
    2,253
    Likes Received:
    66
    Best Answers:
    0
    Trophy Points:
    225
    #2
    here is a code

    I guess this is what you needed
     
    ludwig, Oct 25, 2006 IP
  3. cancer10

    cancer10 Guest

    Messages:
    364
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thanx for the reply


    that helped
     
    cancer10, Oct 27, 2006 IP