Member Avatar for Guy Perkins

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
  • 87 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by iamchamith
Member Avatar for iamchamith

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.