small light application that can run on win XP and win 7.
we need to create a CSV file with 2 colums. both columns are part number values from an inventory. the 2 columns represent a relationship
User opens desktop GUI and selects a CSV file by browsing local folders (file contains one column and maybe upto 1000 values each less than 20 CHARS)
The application searches a local SQL database table on another PC for matching values in either of 2 fields
The GUI shows a table with all the matching records (table brings 3 fields back from DB and also has checkbox on each line)
User can check all/none or individual checkboxes then click a button
Button action opens prompts for another search of the DB
User enters value and GUI shows results (in same format as GUI table above)
User ticks all/none or individual checkboxes then has button option "create CSV"
"create CSV" button creates a new CSV containing matched values in first search table and second table.
GUI needs a settings tab to setup the database connection
45 freelancers are bidding on average $145 for this job
Hi, I have completed several CSV projects along with SQL Database. I can deliver to you a VB.NET solution to perform the SQL queries etc. Ready to start ASAP. Looking forward to your reply. Regards, Waleed