I know retrieving the data using query but I want to know how retrieve the using Search box: My concept is: If i enter data in textbox and it matches value of records in SQL I need to retrive the rest records If textbox1.text = dr["nam"] Then Textbo4.text= "sdfdsfs" Like that
I am afraid your explanation is not very understandable. Please provide more info if you want that people help you out. You search using the query as follows: SELECT FROM MyTable WHERE FieldOne LIKE '%' + SearchTextBox.Text + '%' Now if it returns anything you want to do what? Please Elaborate!
do you want something like autocomplete, where suggestions will be displayed once you type few characters in the textbox or a simple solution...once you press button "SEARCH" then it executes the query ?