like keyword in sql

Mar 31 2011 7:11 AM
hi,
 

string q1 = "select * from register where areaofspecific like ' %+ TextBox1.Text + % ' and experience= '" + DropDownList1.SelectedItem.Value.ToString() + "'";

i wrote the query like this

but when i execute the query in sql window the correct result will be displayed

i gave the textbox value as .net,sql

in sql table

there is c,c++,java,.net,sql

but nothing will be displayed what can i do


Answers (4)