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