C Sharp to Update MySQL
$10-30 USD
Paid on delivery
Project Budget: 40.00
I need an application to update MySQL database based on an excel (xls/xlsx) file
Application will have config file where I will save the following
MySQL Username
MySQL Password
Table 1
Table 2
MySQL IP
MySQL Port
The path to the Excel File
The excel file has Vehicle ID call vehicle
The query will be as follow
Update Table 1(Get the name of Table 1 from config File) Set Audit = “Present” Where Vehicle = “get the value from Excel File);
Example: Update New_Inventory Set Audit = “Present” Where Vehicle = “7452N”;
Update Table 2(Get the name of Table 2 from config File) Set Audit = “Present” Where Vehicle = “get the value from Excel File);
Example: Update Used_Inventory Set Audit = “Present” Where Vehicle = “3257T”;
I need to have Mac_Address Control and Expiration date in the source code so I Can change it as i need it
I’m paying for this application if I get fired from my job I don’t want them to copy it or use
The application will start from the task scheduler run; update the 2 tables’ then exit
If no excel files found create a log file and add it the error to it
If MySQL is not available create a log file and add it the error to it
Project ID: #13172687
About the project
17 freelancers are bidding on average $46 for this job
Hello Good Day I can develop this small application in C# which can update MySQL with all the configurations outlined. Looking forward to work with you. Thanks Rinsad
Hello I'm a 15 years experienced developer, I will deliver a Professional High quality solution to your project, I invite you to visit my profile to see what others have said about my past work, Thnaks In advance for More
I can create such C# app in less than a day and all I need to start is Excel file sample. You'll get VS2015 project where you can set expiration date and mac address inside source code. Thanks. Roman
Hello. How are you. I have read and understood the project. I have strong knowledge in Database. And I'm expert in Java ,C#, C/C++, Python ,PHP etc. I'm interested this project. So, firstly I want to discuss wi More
I have 5+ years experience in C# .NET Technologies. I have 10s of such things in almost everyday.
Hi, I'm Ahmed. I just saw your project topic and found that you want to create a program to update data from xls files to MySQL database. I have 9+ years experience of C# programming and 7+ years of MySQL,I provide you More
Hi, my name is Woody and I'm from Brazil. I can do it, could it be in C++? I would love to work with you in your project, feel free to call me in the freelancer.com chat to talk with me about your requirements and More
Hi, I can do this task. We worked on your other project already :) ================================================================================================================================================ More
Hello Last 8 years I have been used ASP.NET MVC and WEBAPI - they were mostly used for web sites. Some projects were developed for web and mobile devices, via Web services and using SignalR library we adopt them More
When I`m starting with some project I`m doing my best. I`m precise, hard working person. I would like to work with you.