I searched but I could not find anything similar to what I need so I will appreciate your help. I have an aspx page that I want to create new textbox fields dynamically upon user request (this is the easy part). The user can ask for any number of fields since they will be used to filter an SQL server table. To make a long story short the table has 23 columns and the user can create multiple textbox for each column so that the general SQL query will search according to the text he will enter in those textbox. For instance - the user can choose the 'type' field and create 3 textbox which he will enter 'b' for the first, 'c' for the second and 'e' for the third so the query will look something like that:
SELECT *
FROM table_name
WHERE type like '%b%' or type like '%c%' or type like '%e%'
I hope you can understand what I'm looking for, Any help will be great...
So I got myself different number of text boxes which I need to create and than use for my SQL query - ashaked 2012-04-04 16:52
Do a for each loop with all the relevant textboxes. In there you can create the SQL Query and add or type like '%X%'
blocks for any nuber of textboxes the user has created. This way the SQL Query will always have the dynamic count of or type like '%c%'