Question about SqlDataAdapter.RowUpdating Event

[Programatix]

Hi,

I'm working on a WebService project. I'm trying to validate data before they
are updated to the database by handling the RowUpdating event for a
SqlDataAdapter.

The data being handled has DataRelation which is related to another
DataTable. As for that, I also need to retrieve the DataRelation from the
current row being updated. I wrote a code which look something like this,
Dim relation As DataRelation
For Each relation In e.Row.Table.ChildRelations
Dim rows As DataRow()

' e.Row.GetChildRows(relation) will always return nothing
rows = e.Row.GetChildRows(relation)
Next

If you try this code, e.Row.GetChildRows(relation) will always return
nothing even though the DataTable which contains the DataRow has
DataRelation.

Beside that, the e.Row.HasErrors and e.Row.RowError properties will also
return nothing.

Is this a bug in .NET Framework 1.1 or I need to change the coding.

Thanks.

[Armin Zingler]

"Programatix" <pr*********@nospam.com> schrieb

Newsgroups:

microsoft.public.dotnet.framework,microsoft.public .dotnet.framework.adonet,m
icrosoft.public.dotnet.framework.webservices,micro soft.public.dotnet.general
,microsoft.public.dotnet.languages.vb
Whenever making crossposts, please use *only* the appropriate groups. This
is not related to VB.Net.

Armin

[Programatix]

I've finally found where the problem lies. It's my fault actually. When I
asked the SqlDataAdapter to update to database, I used the following
overloaded Update method,
Overloads Public Function Update(DataTable) As Integer

Because of this, the information included in the DataSet is not included in
the RowUpdating event.

The original idea to use DataTable instead of DataSet is because in my
opinion, sending the DataTable will be faster than DataSet, but it seems to
produce more problem than I have ever thought of.

Sigh...

Thanks for reading.

"Programatix" <pr*********@nospam.com> wrote in message
news:eK**************@TK2MSFTNGP10.phx.gbl...

Hi,

I'm working on a WebService project. I'm trying to validate data before they are updated to the database by handling the RowUpdating event for a
SqlDataAdapter.

The data being handled has DataRelation which is related to another
DataTable. As for that, I also need to retrieve the DataRelation from the
current row being updated. I wrote a code which look something like this,
Dim relation As DataRelation
For Each relation In e.Row.Table.ChildRelations
Dim rows As DataRow()

' e.Row.GetChildRows(relation) will always return nothing
rows = e.Row.GetChildRows(relation)
Next

If you try this code, e.Row.GetChildRows(relation) will always return
nothing even though the DataTable which contains the DataRow has
DataRelation.

Beside that, the e.Row.HasErrors and e.Row.RowError properties will also
return nothing.

Is this a bug in .NET Framework 1.1 or I need to change the coding.

Thanks.

[Programatix]

Why is it not related to VB .Net? I'm using VB .Net to write the code. As
for that, it should be related to VB .Net.

"Armin Zingler" <az*******@freenet.de> wrote in message
news:u4**************@TK2MSFTNGP10.phx.gbl...

"Programatix" <pr*********@nospam.com> schrieb

Newsgroups:

microsoft.public.dotnet.framework,microsoft.public .dotnet.framework.adonet,m icrosoft.public.dotnet.framework.webservices,micro soft.public.dotnet.general ,microsoft.public.dotnet.languages.vb
Whenever making crossposts, please use *only* the appropriate groups. This
is not related to VB.Net.

Armin

[Programatix]

Still sometime, anyone with VB skill could have known the solution and that
someone, since always used VB only browse the VB newsgroup, might not browse
the ADO .Net newsgroup. And in this case, that someone might not know that
his/her help is needed.

:)

"Armin Zingler" <az*******@freenet.de> wrote in message
news:Oz**************@TK2MSFTNGP11.phx.gbl...

"Programatix" <pr*********@nospam.com> schrieb

Why is it not related to VB .Net? I'm using VB .Net to write the
code. As for that, it should be related to VB .Net.
Would it be the same question in C#? If yes, it's not related to VB. As

the subject (and the question) shows, it's a about ADO.Net and the Framework
class library, no matter which language you use. So it's not a VB.Net
related question, IMHO.

Armin

[Armin Zingler]

"Programatix" <pr*********@nospam.com> schrieb

Still sometime, anyone with VB skill could have known the solution
and that someone, since always used VB only browse the VB newsgroup,
might not browse the ADO .Net newsgroup. And in this case, that
someone might not know that his/her help is needed.

:)

Then you should also post to alt.binaries.cartoons.french because there
might be someone who can help you. ;-)

Armin

[Kathleen Dollard]

Depends on whether you want a good answer, or any answer.

I actually skimmed by this yesterday because I was in a rush and saw that
Armin had answered you.

Good that you answered your question, but I think crossposting rarely helps
you get the answer your looking for (except when the issue lies on teh seam
between multiple groups).

--
Kathleen (MVP-VB)

"Programatix" <pr*********@nospam.com> wrote in message
news:ej**************@TK2MSFTNGP10.phx.gbl...

Still sometime, anyone with VB skill could have known the solution and that someone, since always used VB only browse the VB newsgroup, might not browse the ADO .Net newsgroup. And in this case, that someone might not know that
his/her help is needed.

:)

"Armin Zingler" <az*******@freenet.de> wrote in message
news:Oz**************@TK2MSFTNGP11.phx.gbl...

"Programatix" <pr*********@nospam.com> schrieb

Why is it not related to VB .Net? I'm using VB .Net to write the
code. As for that, it should be related to VB .Net.

Would it be the same question in C#? If yes, it's not related to VB. As

the

subject (and the question) shows, it's a about ADO.Net and the Framework
class library, no matter which language you use. So it's not a VB.Net
related question, IMHO.

Armin

[Programatix]

In my case now, I want any answer.

Anyway, enough is enough. There is no need for arguement here. Armin has his
point but sometime, that someone needed a quick respond and any responds are
considered good, even though it's not.

"Kathleen Dollard" <ka******@mvps.org> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Depends on whether you want a good answer, or any answer.

I actually skimmed by this yesterday because I was in a rush and saw that
Armin had answered you.

Good that you answered your question, but I think crossposting rarely helps you get the answer your looking for (except when the issue lies on teh seam between multiple groups).

--
Kathleen (MVP-VB)

"Programatix" <pr*********@nospam.com> wrote in message
news:ej**************@TK2MSFTNGP10.phx.gbl...

Still sometime, anyone with VB skill could have known the solution and

that

someone, since always used VB only browse the VB newsgroup, might not

browse

the ADO .Net newsgroup. And in this case, that someone might not know that his/her help is needed.

:)

"Armin Zingler" <az*******@freenet.de> wrote in message
news:Oz**************@TK2MSFTNGP11.phx.gbl...

"Programatix" <pr*********@nospam.com> schrieb
> Why is it not related to VB .Net? I'm using VB .Net to write the
> code. As for that, it should be related to VB .Net.

Would it be the same question in C#? If yes, it's not related to VB. As

the

subject (and the question) shows, it's a about ADO.Net and the

Framework class library, no matter which language you use. So it's not a VB.Net
related question, IMHO.

Armin