C# MYSQL Application
This project was awarded to thelogicgates1 for $175 USD.Get free quotes for a project like this
Project Budget$30 - $250 USD
This is a MYSQL multiuser system where users can post notes (Details) against a list of primary records (Parents) via a C# application run on their individual desktops.
I have a "Parent" table with a integer primary key field and text description field as well as some other fields. I have another "Detail" table that has a second integer key field as well as a reference field back to the first table, a TEXT notes field, and and some other fields (user, timeStamp, etc). Its similar to an Order/LineItems setup. The PK's shown below can be adjusted as per your suggestions.
I need a C# windows application that can scroll through the Parent table (Alerts) and view and make entries (Notes), either insert, update, or delete in the Child Table.
A user should only be able to edit or delete their own notes.
An Apply button should post inserts or updates to the notes table as the case may be.
A timed function should indicate to the user that new parent or detail records are available, and which of the detail records has new inserts or updates.
A refresh button should update the Parent records or the Detail records.
More features may be added as we go.
I can make the parent and detail tables on my MYSQL server available to the developer.
The table specs are:
INT pk (Primary Key)
DATETIME timeStamp [sortable]
VHARCHAR sSymbol [sortable]
VHARCHAR oSymbol [sortable]
[Some other fields, sortable]
INT fk (references the Parent)
DATETIME postTime (or update time as the case may be)
[possibly some other fields]
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online