delegates

[am72de]

Hi all,

I have a delegate of type OracleRowUpdate dEventArgs which is inherited
from System.Data.Com mon.RowUpdatedE ventArgs and I have the
OleDbRowUpdated EventArgs which is inherited from RowUpdatedEvent Args as
well. Saddly I can't create a delegate in this form:

oracleDataAdapt er.RowUpdated +=
OracleRowUpdate dEventHandler(d a_RowUpdated)

oleDbDataAdapte r.RowUpdated +=
OleDbRowUpdated EventHandler(da _RowUpdated)

private void da_RowUpdated(o bject sender, RowUpdatedEvent Args e) {}

because their events have different signatures:

private void oracleDataAdapt er_RowUpdated (object sender,
OracleRowUpdate dEventArgs e){}

private void oleDbDataAdapte r_RowUpdated (object sender,
OleDbRowUpdated EventArgs e){}

I know it would be very simple to call the "da_RowUpda ted"-Method from
oracleDataAdapt er_RowUpdated and from oleDbDataAdapte r_RowUpdated, but
sadly the event has to be set to an assembly which should be completely
database independent, so I have to look for a solution like the first
case.

Is there a possibility to "downcast" the events to RowUpdatedEvent Args
or does anybody knows a better solution?

Thanks in advance
Andy

[billr]

Would it be possible/viable to provide your own event handler/delegate in
which case you will have complete control ... for example:

public delegate DatabaseRowUpda tedEventHandler (object sender, MyEventArgs e)

public enum MyEventArgsType s { ORACLE, OLE };
public class MyEventArgs : EventArgs
{
public readonly MyEventArgsType s DatabaseType;
public MyEventArgs(Eve ntArgs e, MyEventArgsType s dbType) : base(e)
{
DatabaseType = dbType;
}
}
public class MyClass
{
public event DatabaseRowUpda tedEventHandler DatabaseRowUpda tedEvent;
public MyClass()
{
// other stuff
oracleDataAdapt er.RowUpdated += OracleRowUpdate dEventHandler(_ oracle);
oleDbDataAdapte r.RowUpdated += OleDbRowUpdated EventHandler(_o le);
}

private void _oracle(object sender, OracleRowUpdate dEventArgs e)
{
try
{
DatabaseRowUpda tedEvent(sender ,
new MyEventArgs(e,
MyEventArgsType s.ORACLE);
}
catch(NullRefer enceException) { }
}
private void _ole(object sender, RowUpdatedEvent Args e)
{
try
{
DatabaseRowUpda tedEvent(sender ,
new MyEventArgs(e,
MyEventArgsType s.OLE);
}
catch(NullRefer enceException) { }
}
}

--
--

Of all words of tongue and pen, the saddest are: "It might have been"

[am72de]

Hi billr,

unfortunately not. Because of the inner structure of the application, I
can't implement the class MyClass to encapsulate the DataDapters (some
parts are third party products and all the dataAdapters in the code are
generated in one static method which gives a IDbDataAdapter-Interface
back). I can access the original dataadapter only in the moment of
creation, after that I have only a IDbDataAdapter-Interface.

I guess I have to create an array and store the original dataadapters
and the accessory delegates. I assign the _oracle and _ole events like
your example and in _oracle/_ole I search the associated dataadapter in
addiction to the "sender" and so I can call the RowUpdatedEvent Args.
- just a little bit beside your idea :-)
- and sadly a little bit more unkind.

Thanks
Andy

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,
What you can do is create one method with each signature these method would
convert the different arguments they receive in a common format and then
call a method which does the work. Now alkl you have to do is creating a way
to transform both parameters ( those received in
OracleRowUpdate dEventHandler and OleDbRowUpdated EventHandler ) in a common
format.

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
<am****@yahoo.d e> wrote in message
news:11******** **************@ g43g2000cwa.goo glegroups.com.. .

Hi all,

I have a delegate of type OracleRowUpdate dEventArgs which is inherited
from System.Data.Com mon.RowUpdatedE ventArgs and I have the
OleDbRowUpdated EventArgs which is inherited from RowUpdatedEvent Args as
well. Saddly I can't create a delegate in this form:

oracleDataAdapt er.RowUpdated +=
OracleRowUpdate dEventHandler(d a_RowUpdated)

oleDbDataAdapte r.RowUpdated +=
OleDbRowUpdated EventHandler(da _RowUpdated)

private void da_RowUpdated(o bject sender, RowUpdatedEvent Args e) {}

because their events have different signatures:

private void oracleDataAdapt er_RowUpdated (object sender,
OracleRowUpdate dEventArgs e){}

private void oleDbDataAdapte r_RowUpdated (object sender,
OleDbRowUpdated EventArgs e){}

I know it would be very simple to call the "da_RowUpda ted"-Method from
oracleDataAdapt er_RowUpdated and from oleDbDataAdapte r_RowUpdated, but
sadly the event has to be set to an assembly which should be completely
database independent, so I have to look for a solution like the first
case.

Is there a possibility to "downcast" the events to RowUpdatedEvent Args
or does anybody knows a better solution?

Thanks in advance
Andy

[am72de]

Hi,

because there are more than one dataadapter and all of them are created
in a single static Method which returns an IDbDataAdapter-Interface the
challenge is exact the transformation - see my answer to billr

Thanks
Andy