The client will need a functional C# project that demonstrates how controls like comboboxes and datetime pickers can be created at runtime based on information stored in an Excel spreadsheet table.
These controls must be data bound and the SQL should be set at the time the control is created based on the appropriate data stored in the excel spreadsheet.
Once we receive the functional code he will then implement the code in his existing Excel COM add-in which will then create the controls dynamically in an existing task pane.
Attached is a screenshot of the existing design time controls that he have and the table and notes regarding the attributes of the specific controls / filters. Also attached please find the excel spreadsheet that contains the proposed excel table.
When the user adds or removes an entry from the excel table and click on a C# button on a from or task pane, then the controls need to be rebuild accordingly.
This example project can be done in VSTO or COM-based, as long as it is done in C# using the Excel interop classes.
Please read the project first and write the word "Understood". Also write your steps and suggestions to complete the project with a short description of what you understood.