Error recovery using DataTable and DataAdapter

I have a general question regarding recovery when encountering an error when accessing data via DataAdapters and DataTables.

Is it okay to build to build the recovery (detection, pause, retry) within the context of the established connection (table and adapter), or is it better to wrap the whole thing in the error recovery and reestablish the entire context on each retry.

I do have a generic logger in place, but I am now in search of the cleanest trap/retry logic.

Thanks,
Steve