Hi
I have two databases, if the first database rejects a record, I want to send the record to the second database and carry on to the next record without reporting an error. How do I do this?
At the moment i have it set up as below, but it still stops and reports and error back.
In the dataAccess class I have removed the catch try around the following line, (if I leave it nothing happens)
RowsUpdated = DataAdapter.Update(ds, ds.Tables[tableName].ToString());
In my business object I have the following
public override void HandleException(Exception e)
{
base.HandleException(e);
this.ExceptionHandled = true;
this.writeToBaddb(e);
}
TIA
Stuart
p.s. I do not have control over the database, and there are various triggers to other databases with rules, so I do not know the rules of whats being rejected before hand