Newbie Question: Firing an Event handler

[Bruce A. Julseth]

SqlDataAdapter has the Event, RowUpdated. How do I set up a handler in my
code for when it fires?

I assume it would look something like,

Private Sub da_RowUpdated(byVal sender as System.Object, ByVal e as
SqlRowUpdatedEventArgs )

in my code. I don't know how to set it up.

Thanks...

Bruce

 

[Ken Tucker [MVP]]

Hi,

Use addhandler. I am assuming the datadapter name is da.

AddHandler da.RowUpdated, AddressOf da_RowUpdated


http://msdn.microsoft.com/library/d...en-us/vblr7/html/vastmaddhandlerstatement.asp

Ken
------------------------------
SqlDataAdapter has the Event, RowUpdated. How do I set up a handler in my
code for when it fires?

I assume it would look something like,

Private Sub da_RowUpdated(byVal sender as System.Object, ByVal e as
SqlRowUpdatedEventArgs )

in my code. I don't know how to set it up.

Thanks...

Bruce

 

[Brian Swanson]

DA also has to be a class level variable declare WithEvents.
At this point you can use AddHandler in code to add the handler, or you
can add "Handles da.RowUpdated" to your da_RowUpdated method...

The line would look like this:

Private Sub da_RowUpdated(ByVal sender as System.Object, ByVal e as
SqlRowUpdatedEventArgs) Handles da.RowUpdated

Hope this helps,
Brian Swanson

 

[Ken Tucker [MVP]]

Hi,

You dont need withevents if you are using addhandler.

Ken
-----------------
DA also has to be a class level variable declare WithEvents.
At this point you can use AddHandler in code to add the handler, or you
can add "Handles da.RowUpdated" to your da_RowUpdated method...

The line would look like this:

Private Sub da_RowUpdated(ByVal sender as System.Object, ByVal e as
SqlRowUpdatedEventArgs) Handles da.RowUpdated

Hope this helps,
Brian Swanson

 

[Brian Swanson]

I stand corrected, I learned something new!

Thanks,
Brian Swanson

 

[Bruce A. Julseth]

Suggestions work like a charm.. Thanks to all...

BTW: Unless I did something wrong, I had to add the "WithEvents" when I
defined my data adapter object
Dim WithEvents da as new SqlDataAdapter
I removed it, as a test, and it wouldn't compile..

Thanks again...

Bruce

 

[Brian Swanson]

You had to add WithEvents if you used the "Handles da.Rowupdated"

 

[Cor Ligthert]

You had to add WithEvents if you used the "Handles da.Rowupdated"And not when you had used the AddHandler clause as Brian showed.

You have two ways to do it.

Cor