how get data from table

Question

This is my table

 

 

 i have a TEXT BOX in aspx page and want to search data from this table .user can put any data witch match any column data of table .

Please tell me how to write query to get data from table .