use of like % in sqlcommand

i have a text box with a search button.on the click of button i want to fetched all the values start with any alphabet say 'm' and bind to grid view.i hv used a query

sqlcommand cmd=new sqlcomand("select * from table where pname='"+textbox1.text+"'%",con);

but it shows that invalid term % how to do this

pls help me

regards

rajeev

Re: use of like % in sqlcommand

Try

SqlCommand cmd=new SqlComand("select * from table where pname LIKE @Name + '%'",con);
cmd.Parameters.AddWithValue("@Name",textbox1.text)

Re: use of like % in sqlcommand

Hi Rajeevinime,

Bug in your query is

select * from table where pname like 'a%'

You have to write like this:

sqlcommand cmd=new sqlcomand("select * from table where pname like '" + textbox1.text + "'%",con);

Hope this helps!