how can i am search the data from database?
just like google

Answer Posted / sharifuddin

for this first design the table like the fields as

EMPNo | EMPNAME | SALARY | DETAILS

Now write the query as follows...

SELECT * FROM EMPLOYE WHERE DETAILS LIKE '%<SEARCH KEY>%'

This is the simplest query for that...

Sharif

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define managed code and managed data in .net?

517


Explain the components of web form in asp.net

554


What are the steps to follow to host a web application on a web server?

596


What is difference between ispostback and autopostback in asp net?

528


How can you handle exceptions in asp.net?

568






What is difference between mvc and asp.net? : Asp.Net MVC

579


Am not able to move the controls on the form freely in asp.net 3.5 even though I selected the position as relative or absolute for those controls. What should I do to overcome this?

1952


What is the page life cycle in asp.net?

569


Can you explain composite pattern?

602


how to transfer the file from client to server using asp.net

601


What is clickid?

564


Can user control be stored in library?

535


What is the use of the tag in the web.config file?

576


How to use a Master Database in Asp.net?

572


What is the file through which you can customize your asp.net application?

558