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