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.

help, how to update a cell? (ASP classic)

Discussion in 'C#' started by JJnacy, Jun 22, 2010.

  1. #1
    Example a cell data is ( "W. jessy B., jessy B., jjessy pager, Ljessy" )

    My Question:
    I want to modify "jessy B." to become "jessy CC." and keep all other info same.

    Please do not change "W. jessy B."



    Thanks / Regards
     
    JJnacy, Jun 22, 2010 IP
  2. bibinsmk

    bibinsmk Active Member

    Messages:
    205
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #2
    Your question is not clear.
     
    bibinsmk, Jun 24, 2010 IP
  3. bitstream

    bitstream Peon

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    database? web page?
     
    bitstream, Jul 4, 2010 IP
  4. m2hmonique

    m2hmonique Peon

    Messages:
    41
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Hello,

    I am not getting your question. Please elaborate more preciously.
     
    m2hmonique, Jul 4, 2010 IP
  5. rajaweb

    rajaweb Peon

    Messages:
    6
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    just replace(", jessy B.,",", jessy CC.,")
     
    rajaweb, Jul 4, 2010 IP
  6. sauravmandhotra

    sauravmandhotra Peon

    Messages:
    22
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    find the cell and edit it using row column funda
     
    sauravmandhotra, Jul 30, 2010 IP
  7. chanda

    chanda Peon

    Messages:
    155
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    write querey
    update tablename set coloumnname='"jessy.cc"' where primary key name=cell key)
     
    chanda, Aug 5, 2010 IP
  8. camjohnson95

    camjohnson95 Active Member

    Messages:
    737
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    60
    #8
    Another alternative, something like:
    
    Dim CellData = "W. jessy B., jessy B., jjessy pager, Ljessy"
    Dim cells() = Split(CellData,", ")
    cells(1) = "jessy CC."
    CellData = Join(cells, ", ")
    
    Code (markup):
     
    camjohnson95, Aug 5, 2010 IP
  9. xeson

    xeson Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    this way is right, first convert the string into Array, then replace the value.
     
    xeson, Aug 5, 2010 IP
  10. bhuppi890109

    bhuppi890109 Member

    Messages:
    1,337
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    48
    #10
    ur question is not clear what do u want...do u want to update the cell directly in to database or by using querey
     
    bhuppi890109, Aug 8, 2010 IP
  11. JJnacy

    JJnacy Peon

    Messages:
    448
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #11
    Thanks I though about Split array too.
     
    JJnacy, Aug 20, 2010 IP