searching using gridview

[Kunal P]

hi i am developing a web based application usin c#. i wanted to perform some searching functionality in the website. i have laid down some fields such as Name, Age. now i want the user can perfrom a search on any of these parameters. eg. if he just wants to perform the search on name, he may or if he wants on bothe the params, he is able. how shud i do. in the sql i tried with AND. but for AND. you wud need to specify both the params..

Kunal

[John L Ponratnam]

Hi, In using queies i can help u. eg: select * from tablename where (''='aaa' or Name='aaa') and (0=16 or Age=16) check it out with this query

Regards, LEE

[Kunal P]

hi thankx for replying.. but the querying is asking for both the parameters.

Kunal