Can any one help me to write code for search from grid view.

See more:

C#5.0

i have joined two tables using left join and displayed it in a gridview. Now I want to search a particular row in that view according to the column 'Name'.

What I have tried:

I did the query for joining the two tables in sql:

SELECT HM.DELETED,HM.ISACTIVE,HM.ID AS ID, HM.NAME as NAME,HM.MOBILE AS MOBILE,HM.EMAIL AS EMAIL,HM.WEBSITE AS WEBSITE,STM.STATE_NAME AS STMSTATE FROM HOSPITAL_MASTER AS HM LEFT JOIN STATE_MASTER AS STM ON STM.ID=HM.STATE_ID WHERE HM.DELETED=0 and HM.ISACTIVE=1 ORDER BY NAME

and in code behind, for searching the particular row in that view i did the following in page load
Search1.StrQry = "select * from HOME_NURSE_REGISTRATION ";