asp.net - How to search the multi column of database using gridview and textbox? -

means if have 2 columns in database namely name & email

i wanna search users or email entering either name or email on textbox after clicking search button record displayed in gridview ?

can tell me select query ?

example of www.google.com

the following selects usernames or emails contain search term:

select *  userstable username '%' + @searchtext + '%'     or useremail '%' + @searchtext + '%'