Search into multiple columns from Single textbox !

Question

What is the best way to search from Table(database) using a single text-box. Using LIKE operator with every column name in SQL query is quite complicated when we had 10-15+ columns !!

Bikesh Srivastava · Answer

Try This. http://www.c-sharpcorner.com/blogs/filter-datagridview-rows-depending-upon-value-in-textbox1

Midhun T P · Answer

Hi please check below link. You will get the solution - https://www.mssqltips.com/sqlservertip/1522/searching-and-finding-a-string-value-in-all-columns-in-a-sql-server-table/