Click here to Skip to main content
15,903,679 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Haii Senior..


My requirement is to Create Queries Based On input From UI.User is allowed to Search by specifying only field names. This Search will act as a general search option For any databases which requires only initial Configuration.

What else should i use for this purpose..IE which all tools will help me Doing this..


Can anybody help me ...

Thank u...
Posted

By field names I assume your UI displays the column names or their aliases to the user. If a user select a field and specifies a value, he/she can search a table based on that.

You can use dynamic sql for that.

http://www.benkotips.com/pages/DynamicSQL.aspx[^]
 
Share this answer
 
Comments
anish.karunakaran 30-Mar-12 6:29am    
haii Samresh.ss..
Is there any other tool to integrate so that it gets simpler..
LINQ or any Other..
sjelen 6-Apr-12 6:07am    
This should be very easy to solve using LINQ
I lack the knowledge of any such tools. What I meant was, that you can create the queries dynamically.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900