Home All Groups Group Topic Archive Search About

Can the RowUpdating event make the Update skip a row?

Author
11 Dec 2004 7:17 PM
John Saunders
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

Author
16 Dec 2004 12:52 AM
Michelle Hlaing
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
>
>
>
Author
16 Dec 2004 2:31 PM
John Saunders
Show quote
"Michelle Hlaing" <i-m***@online.microsoft.com> wrote in message
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.

Thanks, Michelle, I saw that documentation.

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

AddThis Social Bookmark Button