Like

[OuTCasT]

hi everyone

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 words

and 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 ?

[Delerna]

You can pass the keywords to a stored proc via parameters and then write a query that uses those parameters to return a recordset back to the web page