hi ,
In my project i need to search with multiple options and retrieved the records from database and display it in a gridview.I am able to do with one option but not with multiple options..please someone help me to do that
Regards
Anju
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Girish SapariyaPosted Nov 26, 2013, 12:55 AM
Multiple search means, you will have multiple options for user to check with?
or
you can use same search box, but search for string in different fields.
You can use this query in order to acheive it:
select * from TableName
where ColumnName1 like 'txtsearchtext' OR ColumnName2 like 'txtsearchName'
This way you can add multiple columns for same string.
Hope this will help you.
Please let us know if it works for you
Satyapriya NayakPosted Nov 25, 2013, 1:05 PM