I have a class named MyClas

That have a method named

Public sub CallAllInsertEvent
'Here i want to write code to loop all instances
'of this class and and Call InsertEvent of all instances
'No matter if they are on another client PC
End sub

Public sub InsertEvent
Raiseevent Myevent
end sub

Is there a way to have access to instances or store them in a shared array by all instances?
------------------------

I want to do this, probably there is another way to do it.

I have form that monitor production batches, the idea is to know where are the batches.

right now my form has a timer that is querying the table and removing adding or changing nodes in a treeview.

I want to make a class that listen for triggers in my sql server database.

so in the triggers i will instanciate the class and call CallAllInsertEvent method, so if the form is opened the instance of the class will raise the proper event and i will remove the node from the treeview.

This way i don't need a timer and the form will be synchronized with changes to the table.

or

Is there an easy way to get triggers from visual basic?

Thanks in advace.