I'm working on a Console Application that is pulling data from other systems and databases. I would like to
1. have the datareader loop through a table and select the distinct employee ID
2. as each employee ID is read, I will pass the ID as a parameter and read and retrieve data from another table.
3. populate the third table with the new data.
I would appreciate any help you could provide to help me get this project done sooner.
Thanks in advance.
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel.
Part 1 of this series discussed basic error handling code using VBA.