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.
Thanks

Hi
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