Sample C# Winform with MySQL database
Budget: $15 – $25 USD
I am having difficulties wrapping my head around just how to use Visual Studio Datasets (connected to a set of tables in MySQL) in a Winform. The trick is that the DataGridView on the form is not connected to the dataset as there need to be transformations written between what shows on the form (loaded from CSV for example) and what's going to end up in the database. So Button 1 is load the winform DGV, Button 2 Verify the form data is consistent which needs calls into the DB/other datasets (other tables) to validate, Button 3 is empty the table and insert new rows into it.
This will probably be an iterative project and what you call the forms and database/tables is not important. What's important is the primary key on the MySQL DB, the datasets and table adapter connections, and causing what you put in the datasets to persist in the MySQL tables.
I'll pay for assistance, but this old (straight sql programmer) is having difficulty getting something that should be terribly simple to work and I'm probably missing a concept.
Ask away, I'll answer, but really I just need some concrete examples and I'll be happy to pay someone who can provide them and answer a few questions when it's done.
This will probably be an iterative project and what you call the forms and database/tables is not important. What's important is the primary key on the MySQL DB, the datasets and table adapter connections, and causing what you put in the datasets to persist in the MySQL tables.
I'll pay for assistance, but this old (straight sql programmer) is having difficulty getting something that should be terribly simple to work and I'm probably missing a concept.
Ask away, I'll answer, but really I just need some concrete examples and I'll be happy to pay someone who can provide them and answer a few questions when it's done.