How to stop RowChanging events from firing on fill

[Denise]

I just realized the DataTable_RowChanging events were firing when I called
Fill method of the DataAdapter! It fires TWICE for each row loaded. I
thought these were only supposed to be called when data was actually being
edited.

I am using bound textbox controls on the form. Could that have anything to
do with it? Does anyone know how to stop the RowChanging events from
firing?

Thanks!
Denise

[CJ Taylor]

You can't stop an inherit event like that from firing... you can only "not
handle" it...
"Denise" <we******@indy.rr.com> wrote in message
news:bS****************@fe1.columbus.rr.com...

I just realized the DataTable_RowChanging events were firing when I called
Fill method of the DataAdapter! It fires TWICE for each row loaded. I
thought these were only supposed to be called when data was actually being
edited.

I am using bound textbox controls on the form. Could that have anything to do with it? Does anyone know how to stop the RowChanging events from
firing?

Thanks!
Denise

[solex]

Denise,

Not sure why this is happening. I am now assuming that you are doing some
processing in this event that you do not want to happen when the DataAdapter
is being filled. If this is the case then you can handle this in a couple
of ways I can think of:

(1) Define a class level variable call bLoading. Before you call the fill
method set bLoading=True and then set it to False after the fill method. In
the event RowChanging only process if bLoading=False

(2) Do not let VB.NET define the event handler for RowChanging (remove the
handles part of the method declaration) then use a combo of RemoveHandler
and AddHandler before and after the fill method.

Dan

"Denise" <we******@indy.rr.com> wrote in message
news:bS****************@fe1.columbus.rr.com...

I just realized the DataTable_RowChanging events were firing when I called
Fill method of the DataAdapter! It fires TWICE for each row loaded. I
thought these were only supposed to be called when data was actually being
edited.

I am using bound textbox controls on the form. Could that have anything to do with it? Does anyone know how to stop the RowChanging events from
firing?

Thanks!
Denise

[One Handed Man [ OHM# ]]

Solex Vs CJ, coming to a Cinema near you soon.

:)

CJ Taylor wrote:

You can't stop an inherit event like that from firing... you can only
"not handle" it...
"Denise" <we******@indy.rr.com> wrote in message
news:bS****************@fe1.columbus.rr.com...

I just realized the DataTable_RowChanging events were firing when I
called Fill method of the DataAdapter! It fires TWICE for each row
loaded. I thought these were only supposed to be called when data
was actually being edited.

I am using bound textbox controls on the form. Could that have
anything to do with it? Does anyone know how to stop the
RowChanging events from firing?

Thanks!
Denise

--
Best Regards - OHM

O_H_M{at}BTInternet{dot}com

[CJ Taylor]

And you thought Oscar DeLahoya (sp?) matches were big...

=)
"One Handed Man [ OHM# ]" <O_H_M{at}BTInternet{dot}com> wrote in message
news:On**************@TK2MSFTNGP12.phx.gbl...

Solex Vs CJ, coming to a Cinema near you soon.

:)

CJ Taylor wrote:

You can't stop an inherit event like that from firing... you can only
"not handle" it...
"Denise" <we******@indy.rr.com> wrote in message
news:bS****************@fe1.columbus.rr.com...

I just realized the DataTable_RowChanging events were firing when I
called Fill method of the DataAdapter! It fires TWICE for each row
loaded. I thought these were only supposed to be called when data
was actually being edited.

I am using bound textbox controls on the form. Could that have
anything to do with it? Does anyone know how to stop the
RowChanging events from firing?

Thanks!
Denise

--
Best Regards - OHM

O_H_M{at}BTInternet{dot}com

[One Handed Man [ OHM# ]]

(sp?) ?

Regards - OHM

CJ Taylor wrote:

And you thought Oscar DeLahoya (sp?) matches were big...

=)
"One Handed Man [ OHM# ]" <O_H_M{at}BTInternet{dot}com> wrote in
message news:On**************@TK2MSFTNGP12.phx.gbl...

Solex Vs CJ, coming to a Cinema near you soon.

:)

CJ Taylor wrote:

You can't stop an inherit event like that from firing... you can
only "not handle" it...
"Denise" <we******@indy.rr.com> wrote in message
news:bS****************@fe1.columbus.rr.com...
I just realized the DataTable_RowChanging events were firing when I
called Fill method of the DataAdapter! It fires TWICE for each row
loaded. I thought these were only supposed to be called when data
was actually being edited.

I am using bound textbox controls on the form. Could that have
anything to do with it? Does anyone know how to stop the
RowChanging events from firing?

Thanks!
Denise

--
Best Regards - OHM

O_H_M{at}BTInternet{dot}com

--
Best Regards - OHM

O_H_M{at}BTInternet{dot}com

[CJ Taylor]

sp? = "is this the correct spelling? I really don't know, but I don't want
to look like a jacka$$"

hows that work for ya.

=)

"One Handed Man [ OHM# ]" <O_H_M{at}BTInternet{dot}com> wrote in message
news:uR**************@TK2MSFTNGP09.phx.gbl...

(sp?) ?

Regards - OHM

CJ Taylor wrote:

And you thought Oscar DeLahoya (sp?) matches were big...

=)
"One Handed Man [ OHM# ]" <O_H_M{at}BTInternet{dot}com> wrote in
message news:On**************@TK2MSFTNGP12.phx.gbl...

Solex Vs CJ, coming to a Cinema near you soon.

:)

CJ Taylor wrote:
You can't stop an inherit event like that from firing... you can
only "not handle" it...
"Denise" <we******@indy.rr.com> wrote in message
news:bS****************@fe1.columbus.rr.com...
> I just realized the DataTable_RowChanging events were firing when I
> called Fill method of the DataAdapter! It fires TWICE for each row
> loaded. I thought these were only supposed to be called when data
> was actually being edited.
>
> I am using bound textbox controls on the form. Could that have
> anything to do with it? Does anyone know how to stop the
> RowChanging events from firing?
>
> Thanks!
> Denise

--
Best Regards - OHM

O_H_M{at}BTInternet{dot}com

--
Best Regards - OHM

O_H_M{at}BTInternet{dot}com

[One Handed Man [ OHM# ]]

OK, Now I understand and its me thats the Jackass !
CJ Taylor wrote:

sp? = "is this the correct spelling? I really don't know, but I
don't want to look like a jacka$$"

hows that work for ya.

=)

"One Handed Man [ OHM# ]" <O_H_M{at}BTInternet{dot}com> wrote in
message news:uR**************@TK2MSFTNGP09.phx.gbl...

(sp?) ?

Regards - OHM

CJ Taylor wrote:

And you thought Oscar DeLahoya (sp?) matches were big...

=)
"One Handed Man [ OHM# ]" <O_H_M{at}BTInternet{dot}com> wrote in
message news:On**************@TK2MSFTNGP12.phx.gbl...
Solex Vs CJ, coming to a Cinema near you soon.

:)

CJ Taylor wrote:
> You can't stop an inherit event like that from firing... you can
> only "not handle" it...
>
>
> "Denise" <we******@indy.rr.com> wrote in message
> news:bS****************@fe1.columbus.rr.com...
>> I just realized the DataTable_RowChanging events were firing
>> when I called Fill method of the DataAdapter! It fires TWICE
>> for each row loaded. I thought these were only supposed to be
>> called when data was actually being edited.
>>
>> I am using bound textbox controls on the form. Could that have
>> anything to do with it? Does anyone know how to stop the
>> RowChanging events from firing?
>>
>> Thanks!
>> Denise

--
Best Regards - OHM

O_H_M{at}BTInternet{dot}com

--
Best Regards - OHM

O_H_M{at}BTInternet{dot}com

--
Best Regards - OHM

O_H_M{at}BTInternet{dot}com