troubleshooting Question

Error recovery using DataTable and DataAdapter

Avatar of Steve Marshall
Steve MarshallFlag for United Kingdom of Great Britain and Northern Ireland asked on
Visual Basic.NET
1 Comment1 Solution20 ViewsLast Modified:
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.

Steve Marshall
IT Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros