You have chosen to sponsor your bid up to a maximum amount of .
hi to all,
I need to create an application with vb.net (2008) by consulting a database using mysql connector Mysql.data 5.1.7 (you can not change it because it is already installed on the machines this connector).
attached attach the database schema to consult.
the program must be able to filter / draw between two dates entered, the field "operator" (or all operators), and the field "chiamatoda" (or called by all) the following values:
1) in datagrid view and print the invalid records defined by the "end time service" equal to "#"
2) in datagrid view and print the valid records defined by the fields "service start time" and "end time service" are different from the "#".
2.1) of the valid values defined to be calculated (without being stored) the time between "now the end of service" and "service orar beginning."
2.2) of the valid values defined to be calculated (without being stored) the time between "now start service" and "time release"
2.3) of all time has to be defined valid calculated the arithmetic mean of all values of item 2.1 and item 2.2
3) in datagrid view and print the records that have a value of "1" in the "liking"
3.1) to view and print the records that have the field "liking" = 1 and "gradimentonegativo" that can 'take 4 values.
further details and / or examples will be provided to developing
thanks for your care