update button doesnt work in gridview RSS

• • Reply
  

  Hunain Hafee...

  Member

  238 Points

  639 Posts

  update button doesnt work in gridview

  Nov 22, 2012 11:57 AM|LINK

  when i click update then nothing updates , 

  happened for the first time

  i filled gridview with this query 

  select tblApplication.applicationid, tblApplication.advid, tblJobAdv.advtitle, tblUser.userid, tblUser.fullname,tblApplication.shortList
  from tblApplication inner join tblUser
  ON tblApplication.userid = tblUser.userid
  inner join tblJobAdv
  ON tblApplication.advid = tblJobAdv.advid

  now for update i wrote 

  update tblApplication SET shortList= @shortList where applicationid= @ applicationid

  and defined parameters also but still don't work at all. 

  no error , but it don't update anything
  

  Hunain Hafeez
  • Edited by Hunain Hafeez on Nov 22, 2012 11:58 AM
  • Edited by Hunain Hafeez on Nov 22, 2012 11:58 AM
• • Reply
  

  Hunain Hafee...

  Member

  238 Points

  639 Posts

  Re: update button doesnt work in gridview

  Nov 22, 2012 12:05 PM|LINK

  same problem with delete 

  Hunain Hafeez
• • Reply
  

  oned_gk

  All-Star

  31814 Points

  6507 Posts

  Re: update button doesnt work in gridview

  Nov 22, 2012 12:28 PM|LINK

  set applicationid as gv datakeynames
  Programming to simplify, dont look for hard way
  • Marked as answer by Hunain Hafeez on Nov 22, 2012 12:45 PM
• • Reply
  

  Hunain Hafee...

  Member

  238 Points

  639 Posts

  Re: update button doesnt work in gridview

  Nov 22, 2012 12:48 PM|LINK

  oh thanks man, DONE
  but wondering that why applicationid wasn't assigned to datakeyname,

  it is always assigned by default to gridview when i use wizard , but why not this time , help ?

   

  Hunain Hafeez
• • Reply
  

  oned_gk

  All-Star

  31814 Points

  6507 Posts

  Re: update button doesnt work in gridview

  Nov 23, 2012 01:01 AM|LINK

  I think because auto datakeynames only work for single table select command.

  Programming to simplify, dont look for hard way
  • Marked as answer by Hunain Hafeez on Nov 23, 2012 10:47 AM