Hi Stuart,

Does the dataset only contain a single updated record or does it contain many changes that need to be passed back to the first server?

Jon


>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