selecting one row from datagrid

[nclauder]

I want to select one Row from a datagrid so I create a textBbox(txtname) and Button for the user to write the name in textBox and By the click of the button it select the corresponding row. But it's not selecting the row neighther I'm getting any mistake message I'm I missng some thing? I wrote the code on Button_Click sqlCommand as follows:
SqlCommand myCommand = new SqlCommand("SELECT * from employee where fullname Like %+txtname+%" ,con);
Thank you.