Author: persistentDeveloper | Posted on: 7/17/2009 9:13:16 PM | Views : 278

Hi
I would like to take your help in generating a dynamic Search query.
My search.aspx page has DropDownLists and TextBoxes. Few of the controls are mandatory and few are optional. In other words it is not required for the end user to select a value from DropDownList and / or enter Text in TextBoxes for some fieds.(Controls that are not marked with * or labled as Optional).
Some times user may enter data in all TextBoxes and select all the DropDownLists on the Search.aspx page.
So it is generating dynamic search query, which should work even the user just enters data into a TextBox.  
Question
How can I achieve the above and generate dynamic query to send to database on Search_btn click event? I like to have relevant links or code snippe ...

Go to the complete details ...