It's been a while since I have had to create a search box to search and display data from sql data base. Just need a little push to refresh my memory.

your question is not clear to us..
We can create many types of search boxes...
some kinds of search boxes include dorpdown list boxes & we can put some particular key value to search some information
we can write that sql code like that

SELECT * FROM table_name WHERE colonm_name = '"+dropdownlist1.selectitem.value+"'

02) If U use textbox value for search some values,u can use "like" ward in sql.. Like that

SELECT * FROM table_name
WHERE colonm _name like '%"+textbox1.text+"%';

in that case U can got nearest values form database