Manage datagridviews and MySQL tables in C#

In Progress Posted 7 years ago Paid on delivery
In Progress Paid on delivery

I need a project to manage 2 tables, using MySQL and must be done in C#.

The attached tables that will be used are:

Table 1 = data_copy; and

Table 2 = result

The form will contain three datagridview. Two of them will receive the data of the above tables and the third datagridview will be explained furthermore.

These datagridviews will be EACH populated by the press of a button:

Button1 will populate datagridview1 with data of Table1, and

Button2 will populate datagridview2 with data of Table2.

On a third datagridview, also after the click of a button (Button3), do the MySQL Join of these two above tables having field "Lote" as the relationship, and hence populating the datagridview3.

You will notice that you will have a correponding record on Table1 (using "Lote"), that matches each of records with the corresponding "Lote" on Table2. But be aware that there will be records on Table1 that will not have a corresponding match on Table2.

With the datagridview3 populated, another button (Button4) should be placed to solve the following:

Column "Total" (that was derived from Table2) divided by

Column "PesoLote" (that was derived from Table1).

The result should be placed in a new column (in the corresponding cell for each row) in

datagridview3, to be called "ValorGrama".

Be aware of the types of these columns, because here in Brazil we use comma as decimal separator and not a period.

A fifth button (Button5) should be placed next to a textbox1. This textbox will receive a value, and this value (the one just inputted on textbox1), will divide each row cell named "Total" (the "Total" was obtained on the join, derived from Table2) and place the result in a new column (in the corresponding cell for each row, in the same datagridview3), called "PriceUS$". This calculation will be done for each row (field "Total').

Finally, a sixth and last button (Button6), to get the data in datagridview3, and place it in a new table (call it analytical).

***VERY, VERY, VERY IMPORTANT!!!!!! *** Deadline will be taken seriously. If not handed in by the deadline date, don't bother in delivering it anymore. Will ask for someone else to do it. *** Communication is a must. By this, we are talking about your progress, too. So, if you are not going to work that day, please let us know, so we can keep calm on our side and be certain that the project will be completed on time. *** Freelancer will hand in the updated files for our comments and further corrections, on a DAILY basis. This is also very important so I can understand what is going on and come back with some fresh questions and also to assure project corrections don't have to be painful. ***MILESTONE RELEASE POLICY What I need is the project to be done. Completely. Fully. Working. In all it's extent. Period. I don't want half of a project, or a partial schematic, or partial code, or partial something whatever. What I want is the FULL complete project and this is what I am willing to get and, of course, pay for. Accepting a project signifies a freelancer's agreement and obligation to deliver services that match the employer's project specifications. This includes abiding by the delivery deadline and delivering the required output in full. Milestone payments are intended to be released upon verification that all requirements relevant to the milestone payment were met. Partial output does not signify partial payment unless agreed upon by both parties beforehand. By this, I am creating one full milestone only, to be released when all that I asked for up here is delivered, plus the Project Guarantee milestone. This is why I tried to be so criterious about each part. No exceptions will be made. *****PLEASE BID ONLY IF YOU ACCEPT THESE TERMS.

Forget to post here: Code will be compiled on my side, so freelancer must provide the source code (in a rar file, preferably with the .sln)

.NET C Programming C# Programming MySQL

Project ID: #11293257

About the project

Remote project Active 7 years ago