|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Can the RowUpdating event make the Update skip a row?Is it ever possible for a RowUpdating event (SqlRowUpdating, etc.) handler
to cause the Update to skip the row? For instance, if e.Status is set to UpdateStatus.SkipCurrentRow, is the current row still updated? If so, it's not clear from the documentation, and I'd love to see a documentation reference saying that this is true, either in general or for a particular ADO.NET provider. If it's not possible, then does anyone know why not? John Saunders Hi John,
This is what I have found in the help documentation: Member name Continue - The DataAdapter is to continue proccessing rows. ErrorsOccurred - The event handler reports that the update should be treated as an error. SkipAllRemainingRows - The current row and all remaining rows are not to be updated. SkipCurrentRow - The current row is not to be updated. Hope that helps, Michelle ***Disclaimer: This posting is provided "as is" with no warranties and confers no rights.*** -------------------- Show quote >From: "John Saunders" <johnwsaundersiii at hotmail.com> >Subject: Can the RowUpdating event make the Update skip a row? >Date: Sat, 11 Dec 2004 14:17:14 -0500 >Lines: 13 >X-Priority: 3 >X-MSMail-Priority: Normal >X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 >X-RFC2646: Format=Flowed; Original >Message-ID: <uusiRY73EHA.3***@TK2MSFTNGP14.phx.gbl> >Newsgroups: microsoft.public.dotnet.framework.adonet >NNTP-Posting-Host: pool-151-199-53-100.bos.east.verizon.net 151.199.53.100 >Path: cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl >Xref: cpmsftngxa10.phx.gbl microsoft.public.dotnet.framework.adonet:96838 >X-Tomcat-NG: microsoft.public.dotnet.framework.adonet > >Is it ever possible for a RowUpdating event (SqlRowUpdating, etc.) handler >to cause the Update to skip the row? For instance, if e.Status is set to >UpdateStatus.SkipCurrentRow, is the current row still updated? > >If so, it's not clear from the documentation, and I'd love to see a >documentation reference saying that this is true, either in general or for a >particular ADO.NET provider. > >If it's not possible, then does anyone know why not? > >John Saunders > > >
Show quote
"Michelle Hlaing" <i-m***@online.microsoft.com> wrote in message Thanks, Michelle, I saw that documentation.news:11VTImw4EHA.3984@cpmsftngxa10.phx.gbl... > Hi John, > > This is what I have found in the help documentation: > > Member name > > Continue - The DataAdapter is to continue proccessing rows. > ErrorsOccurred - The event handler reports that the update should be > treated as an error. > SkipAllRemainingRows - The current row and all remaining rows are not to > be updated. > SkipCurrentRow - The current row is not to be updated. What I didn't see is whether changing the status within the event will cause the Update operation to obey the new status. Could you check on that for me, please? Thanks, John Saunders |
|||||||||||||||||||||||