I just wanted to ask, i have a web page that allows companies to register there products etc....
now on that page there is a label that says :
Describe your product in 10 wordsand that inturn has 10 textboxes which save to the database.
now i have another page that searches those words and picks up the companies.
instead of binding data to a dropdownlist from the db can i use a SQL query that will search the table in the database and find what the person has entered into the search textbox. ?
[code=sql]select product1,product2,product3 from products where keyword like = "%g%"[/CODE
what i want for the person to do is type in something and then it searches the products in the db for that letter and brings everything back into a gridview for selection ?