SharpDunce
New member
- Joined
- Sep 10, 2014
- Messages
- 2
- Programming Experience
- Beginner
Hello all,
I'm interning at a company and I've been tasked to make a command line c# program that:
- Takes in data from two excel files
- Converts it to a SQL friendly format after error checking and standardizing
- Checks the database for changes, removals and new addictions
- Consolidates the information into the server in one transaction
It has to be relatively quick and robust (error checking, crash-free, etc.). The excel sheets will have a few thousand (under 5) entries that will mostly remain the same with changes and additions here and there.
For most of the day I've been researching, it seems like using ado.net libraries and functions seems like a good way to do it. I made a test program that converted a simple excel table to a DataTable object and uploaded it to a table I made in the SQL database, but it was very simple and had no error checking and validation.
What is the best approach in your opinion? I'm pretty inexperienced with software development, and I haven't done anything past the regular class assignments.
I'm interning at a company and I've been tasked to make a command line c# program that:
- Takes in data from two excel files
- Converts it to a SQL friendly format after error checking and standardizing
- Checks the database for changes, removals and new addictions
- Consolidates the information into the server in one transaction
It has to be relatively quick and robust (error checking, crash-free, etc.). The excel sheets will have a few thousand (under 5) entries that will mostly remain the same with changes and additions here and there.
For most of the day I've been researching, it seems like using ado.net libraries and functions seems like a good way to do it. I made a test program that converted a simple excel table to a DataTable object and uploaded it to a table I made in the SQL database, but it was very simple and had no error checking and validation.
What is the best approach in your opinion? I'm pretty inexperienced with software development, and I haven't done anything past the regular class assignments.