karthi vimala

karthi vimala

  • NA
  • 49
  • 51k

how to match the textbox value to the value in table

Mar 31 2011 4:12 AM
hai,

    i have one doubt in .net in textbox i specify the text seperated by commas (eg: .net,sql)likewise.in sql table i registered one name for that name i specified (.net,sql,java,j2ee) in keyskill field .In .net i retrieve the name by using where condition   

select * from regsiter where keyskill='"+TextBox1.Text+"'

when i execute this query i want to retrieve the row which text is given in textbox should match the data in sql(not accurately);

simply if i entered .net,sql in a textbox
i retrieve which row has .net,sql or any other like java,j2ee but .net is must.
how can i perform this

Thank u

Answers (1)