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