difference between dataset.acceptchanges() and dataadapter.update() in .net RSS

• • Reply
  

  arun_diana20...

  Member

  239 Points

  103 Posts

  difference between dataset.acceptchanges() and dataadapter.update() in .net

  Oct 28, 2008 11:01 AM|LINK

  hi all,

  i want to know about the difference between dataset.acceptchanges() and dataadapter.update().

  Thanks,

  Arun.R

   

• • Reply
  

  DarrellNorto...

  All-Star

  86555 Points

  9624 Posts

  Moderator

  MVP

  Re: difference between dataset.acceptchanges() and dataadapter.update() in .net

  Oct 28, 2008 12:07 PM|LINK

  AcceptChanges only updates your rows in the (in memory) dataset, that is - marks them as "not needed for actual database update". If you want to update your rows to the database, call your tableadapter's Update method. This method will call AcceptChanges on your rows if the rows get successfully updated to the database. The point here is, you should only call AcceptChanges on your rows, if you don't want them to be sent to your database to update records.
  Darrell Norton, MVP
  Darrell Norton's Blog
  Please click "Mark as Answer" if this helped you.
  • Marked as answer by arun_diana2003 on Oct 28, 2008 12:23 PM