Wednesday, 11 September 2013

Options for working with two databases in C#

Options for working with two databases in C#

Ok I`m new to C# and new to Programing. I have taken on a small task(goal)
for writing my own program for work.
Basically this program will take two databases. One data base will be
update weekly (lets call this doctor list) and the other data base will be
updated as needed (lets call this employee).
Basically I want to make my program compare the two databases and look for
any matching employees on this list doctor list.
I can figure out the code for the searching and basic stuff.. But I have
no clue where to begin with databases.
I'm ok with SQL but my problem is that my doctor list comes in a dbf file.
I've looked up converting to access and sql but this program needs to be
easy to use for are hr department.
Is there away to write the conversion? (again new to this)
What kind of options do I have with just working with programing it to
read off an excel sheet?
If I do go the access or sql router do the computers this program run off
of need to have access or sql loaded?
I`m not looking for someone to write me the code.. just point me in a good
directions and answer some questions...

No comments:

Post a Comment