VB.NET desktop VS 2019 CRUD 3 small tables
Budget: €30 – €40 EUR
Note: out of budget bids wil be ignored
Requirement (the formatted version attached )
*Tables
Table Songs fields:
• Id
• Song (String)
• AuthorPtr (link to Authors)
Table Authors fields:
• Id
• Author (String)
Table Documents fields:
• Id
• SongPtr (link to Songs)
• Name (String)
• Address (String)
*Forms
Songs (Main form)
The form has two DGVs, a button to open Authors form, another to refresh after modifying Authors and a text used as filter of Songs.
A flag select the operation mode: Read / Edit.
The Songs DGV is filtered by words in the string Song + Authors.Author.
Documents DGV in Read mode the only show the Name column, and when a cell is clicked the value of the Address field is executed with Shell execute.
*Environment
The database is MS MDB
The database location is passed in the command line. If is empty “..\Release” is assumed.
The project is VB.NET desktop VS 2019
Authors form
Table’s CRUD DGV.
Requirement (the formatted version attached )
*Tables
Table Songs fields:
• Id
• Song (String)
• AuthorPtr (link to Authors)
Table Authors fields:
• Id
• Author (String)
Table Documents fields:
• Id
• SongPtr (link to Songs)
• Name (String)
• Address (String)
*Forms
Songs (Main form)
The form has two DGVs, a button to open Authors form, another to refresh after modifying Authors and a text used as filter of Songs.
A flag select the operation mode: Read / Edit.
The Songs DGV is filtered by words in the string Song + Authors.Author.
Documents DGV in Read mode the only show the Name column, and when a cell is clicked the value of the Address field is executed with Shell execute.
*Environment
The database is MS MDB
The database location is passed in the command line. If is empty “..\Release” is assumed.
The project is VB.NET desktop VS 2019
Authors form
Table’s CRUD DGV.