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
Difference between singleton and singlecall.
Can a master page have more than one contentplaceholder?
What is the use of asp.net web api?
What is the usage of DelegatingHandler?
Where the viewstate is stored after the page postback?
How do you sign out from forms authentication?
List all templates of the repeater control.
Explain the difference between Repeater and Data list control in ASP.NET?
How can you handle errors in Web API?
How can I configure asp.net applications that are running on a remote machine?
Why web api is better than wcf?
Who is using asp.net?
When using the Pager object, inorder to know which page to go, which property you have to set to grid?
How does session state work in asp.net?
1.how to encrpt query string in asp.net? 2.there are 10000 records then i wnat display 5000 records one gridview and 5000 records another grid view what is the process?