locked
multiple fields update using access datasource RRS feed

  • Question

  • User2145053574 posted

     Hi,

     

    iam using MS.Access database and ,binding the gridview with Access datasource

     

    iam trying to update the multiple fields in a particular row ,but it is not supporting

    (iam able to update single field in a row at a time but the pbm is for multiple fields)

     

    can any one plz help regarding this issue 

     

    Thanking you

     

    with regards,

    prasanth

    Monday, February 16, 2009 9:10 AM

Answers

  • User-1199946673 posted

    I'm not quit sure what you mean?

    If
     

    update set uname=@uname,fname=@fname,lname=@lname,address=@address where uid=@uid 
     
    is working, I don't see any reason why
    update set uname=@uname where uid=@uid 
    is not
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, February 21, 2009 12:36 AM
  • User-821857111 posted

     

    update set uname=@uname where uid=@uid ;        (This was not supported in ms-access )

     

    Of course it's supported in ms-access.  I suspect that you have set the ConflictDetection to CompareAllValues, and that's why it wasn't working for you initially, although that's only a guess, as you never showed your code or explained why you thought it "wasn't supported".

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, February 21, 2009 5:51 PM

All replies

  • User-1199946673 posted

    Please show us your code?

    Monday, February 16, 2009 11:37 AM
  • User2145053574 posted

    hi 

     

    my problem will be solved ,for ms-access database ,if we are using ms-access datasource for updating single fild also we have to set all fiels updated ,whatever you given in the select statement

     

    for example,

    select uid,uname,fname,lname,address from temptable;

    if we want to update uname field only based on uid

     we have to set all fields update like

    update set uname=@uname,fname=@fname,lname=@lname,address=@address where uid=@uid

     instead of

    update set uname=@uname where uid=@uid ;        (This was not supported in ms-access )

     

    with regards,

    prasanth

     

     

    Friday, February 20, 2009 11:56 PM
  • User-1199946673 posted

    I'm not quit sure what you mean?

    If
     

    update set uname=@uname,fname=@fname,lname=@lname,address=@address where uid=@uid 
     
    is working, I don't see any reason why
    update set uname=@uname where uid=@uid 
    is not
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, February 21, 2009 12:36 AM
  • User-821857111 posted

     

    update set uname=@uname where uid=@uid ;        (This was not supported in ms-access )

     

    Of course it's supported in ms-access.  I suspect that you have set the ConflictDetection to CompareAllValues, and that's why it wasn't working for you initially, although that's only a guess, as you never showed your code or explained why you thought it "wasn't supported".

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, February 21, 2009 5:51 PM