selecting one row from datagrid

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.

.

Quantcast