Search with multiple Records and display it on gridview

Question

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

Girish Sapariya · Answer

Hi Anju 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 Nayak · Answer

http://www.c-sharpcorner.com/UploadFile/0c1bb2/searching-records-from-database-and-display-in-gridview-usin/