hello friends , this is baji, i have problem in search button
in asp.net,
i have two text boxes and a button , when i enter string or alpha bit in any textbox and click the buton , it will show the all rows starting with the letter to displays.
I written some qury but it will show theall coloumsin the talble.
plzz.
   it's urgent
 any one hilp me the syntax.

this syntax i wriiten .
 st = " select * from data where CompanyName= '" & TextBox1.Text & "' AND Url= '" & TextBox2.Text & "' "


plzz modifiy the syntax.
baji.