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 the features that make asp.net more used framework? : asp.net mvc
Define cookie.
Where session variables are stored?
Can a master page have more than one contentplaceholder?
What is custom events?
What are the contents of cookie?
What is the difference between union and join?
What are Authentication and Authorization?
What is marshalling ? Is it a part of asp.net ?
What is semantic gap?
What are the new login controls in asp.net 2.0?
Is asp.net a programming language?
What are the events in a page life cycle?
How can you make sure that web api returns json data only?
Define xmlvalidatingreader class.