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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / mahendra

note that, when datatype is string i.e. details like
mahendra, then use like this - "select * from employee
where empname like '%" & trim(txtbob.text) "&' ", i used
because to any leading space will be deleted.

if u want to find salary figure that i integer then
"select * from employee where salary >= " & trim
(txtbob.text) "&"

pl.note '%" & '&" for string


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

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More ASP.NET Interview Questions

what is asp dotnet

2 Answers  


is it possible to access website from a remote place, without deploying it on web server?

1 Answers  


What is difference between view state and session state?

0 Answers  


What is an imagemap in asp.net?

0 Answers  


and can u telme how to explain about our job profile if i have 3years of it experiance in dotnet domain and where to start and where to end , and what shoul i tel and what not(can i mention my education ,and family details,......)i am confusiong a lot. can i ask one with your permision, if u have question that u u went tcs interview as 3+years exp so he/she asked tel me about your profile how can u tel and where to stop. please help me as simple as possible i am facing lot in this..............plese can anyone help me i am awaiting for your reply.

1 Answers   TCS,






What does setting a control's EnableViewState property to false accomplish?

1 Answers  


How would you get ASP.NET running in Apache web servers - why would you even do this?

1 Answers   Siebel Systems,


How can you implement the postback property of an asp.net control?

0 Answers  


what are the differences between windows services and web services?

5 Answers   Tech Mahindra,


Explain the difference between panel and groupbox classes using .net?

0 Answers  


What is the best way to search any exact information on google?

3 Answers   Intellevate,


How can we create Tree control in asp.net?

0 Answers  


Categories