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