how can i am search the data from database?
just like google
Answer Posted / 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 View All Answers
What are sharepoint pages?
Explain the page lifecycle of an asp.net mvc? : asp.net mvc
What are asp.net web forms?
What would be salary for 8+ years of experience in ASP.NET in different metro city in india?
What are the advantages and disadvantages of session?
How to create a db connection at one place/page so that we can use that connection for all pages/forms/windows.what r the steps ned to be performed if question not clear,let me know
What do you mean by caching in asp.net?
Why asp.net mvc is better than asp.net? : Asp.Net MVC
What is paging in context of Memory?
How are sessions stored?
How can we register exception filter globally?
is gateway for sms continue connected for sending sms.how?
8. Why do you want to work here?
Explain managed code an un-managed code.
How does asp.net work?