How to create dynamic controls on my query page and query according to them

See more:

C#

ASP.NET

jQuery

SQL-Server-2012

Hello All,

I have a scenario that I have a search form which I have to use for Update and reporting purposes, for that I have to use dynamic generated controls based on search criteria selected from dropdownlist, and according to search criteria I have to generate Textbox or Dropdownlist or Listbox based on data from SQLDB.

I am googling it but only got solutions for the dynamic textbox controls but how to retain their values to use it in my query & how to fill these controls with data from SQLDB.

Do I use enums for that, if yes then how...

Any suggestions will be welcome....

What I have tried:

I have created a from in which I have added dynamic textboxes but can't retain their values in my save button, and also have to use dropdownlist as well.