how can i am search the data from database?
just like google
Answers were Sorted based on User's Feedback
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 |
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 |
what is asp dotnet
is it possible to access website from a remote place, without deploying it on web server?
What is difference between view state and session state?
What is an imagemap in asp.net?
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.
What does setting a control's EnableViewState property to false accomplish?
How would you get ASP.NET running in Apache web servers - why would you even do this?
How can you implement the postback property of an asp.net control?
what are the differences between windows services and web services?
Explain the difference between panel and groupbox classes using .net?
What is the best way to search any exact information on google?
How can we create Tree control in asp.net?