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
How to integrate angular 8 with asp.net mvc 5? : Asp.Net MVC
Can you explain architecture of your project ?
What are the page life cycle events?
Is it true that a Web service must be written in .NET or not?
What is the difference between asp.net and mvc?
What language is asp.net written in?
What are the asp.net 2.0 features?
What are httphandlers and httpmodules and difference between them?
Explain About WebService
Describe the difference between inline and code behind - which is best in?
Can viewstate be accessed in another page?
How many types of validators are there in asp net?
How do we assign page-specific attributes?
How do you implement sql caching in asp.net?
What is difference between view and partial view?