April 2003
Beginner to intermediate
620 pages
21h 48m
English
Content preview from ADO.NET in a NutshellBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Committing and Discarding Changes
When a
DataRow is modified, ADO.NET marks the row as
having a changes and sets the RowState of the
DataRow to Added,
Modified, or Deleted, as
appropriate. ADO.NET also maintains version information by storing
both Original and Current
versions of each row. Together, this information allows ADO.NET or an
application to identify the rows and columns that have been changed.
AcceptChanges and RejectChanges
The AcceptChanges( )
and RejectChanges( )
methods either accept or reject the changes that have been made to
the DataSet since it was last loaded from the data
source or since AcceptChanges( ) was last called.
The AcceptChanges( ) method commits all pending
changes within the DataSet. Calling
AcceptChanges( ) changes the
RowState of Added and
Modified rows to Unchanged.
Deleted rows are removed. The
Original values for the DataRow
are set to the Current values. Calling the
AcceptChanges( ) method has no effect on the data
in the underlying data source.
The AcceptChanges( ) method is implicitly called
on a row when the DataAdapter successfully updates
that row back to the data source when the Update( ) method is called. As a result, when a
DataAdapter is used to update the data source with
the changes made to the DataSet,
AcceptChanges( ) doesn’t need to
be called. Calling AcceptChanges( ) on a
DataSet filled using a
DataAdapter effectively removes all information
about how the DataSet has been changed since it was loaded. This makes it impossible ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.