0

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

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by iamchamith
0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.