C Sharp to Update MySQL

In Progress Posted 7 years ago Paid on delivery
In Progress 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

C# Programming MySQL

Project ID: #13172687

About the project

17 proposals Remote project Active 7 years ago

17 freelancers are bidding on average $46 for this job

rinsadsl

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

$44 USD in 2 days
(591 Reviews)
8.4
CARLOSHUGGINS

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

$80 USD in 3 days
(34 Reviews)
5.9
paskal77

Hello Sir /Ms, I have received the specification of your project and I am sure to be able to develop it, Please check the past projects that I have handled, and check my reviews, what my employers have opined More

$39 USD in 3 days
(63 Reviews)
5.9
gangabass

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

$55 USD in 1 day
(123 Reviews)
6.1
wangbeizou

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

$40 USD in 2 days
(23 Reviews)
4.8
zmgroup

I have 5+ years experience in C# .NET Technologies. I have 10s of such things in almost everyday.

$30 USD in 2 days
(27 Reviews)
4.5
GameHackerPM

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

$40 USD in 0 days
(11 Reviews)
4.1
agodinhost

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

$35 USD in 1 day
(3 Reviews)
2.9
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format More

$40 USD in 3 days
(4 Reviews)
2.5
swapnilmj20056

Hi, I can do this task. We worked on your other project already :) ================================================================================================================================================ More

$45 USD in 3 days
(5 Reviews)
1.9
marksteintech

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

$111 USD in 2 days
(1 Review)
0.0
thekoko89

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.

$40 USD in 2 days
(0 Reviews)
0.0
minhphuonglam94

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0