Using visual studio 2015, I need forms that would connect the VB desktop application with Microsoft SQL database table. The requested action are as follow.
1) Upload excel to SQL - but before the upload few adjustments must be made to the excel file.
2) export from SQL to excel with a template.
3) view SQL data infor a datagridview, edit and save
4) enter new data form
5) edit and update form
6) delete data from table (move it to trash table)
7) datagridview from multiple tables
8) a SQL form client for an admin to view, create, delete, redesign tables etc...
9) based of data in SQL create report
10) live chart form
I just need the codes and samples of the above with explanation and I'll do the rest.