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 |
In a page there is dropdown list with the name of the cities like Bangalore,Pune,Chennai,Other and a text box that would enable the user to enter the name of the city if other is selected. How to enable validation on the text box if other is selected
Differentiate globalization and localization.
What do you mean by serialize and marshalbyref?
What are url fragments?
relacement of websevices in .net 3.0?
You create an assembly to access data in a relational database. This assembly will be used by several ASP.NET applications on your Web server. You need to ensure that all your applications can access the assembly. Which two actions should you take (Each Answer: presents part of the solution.)? (Choose two) A . Run the Assembly Registration tool (Regasm.exe). B . Run the String Name tool (Sn.exe). C . Run the Installer tool (Intallutil.exe). D . Run the Global Assembly Cache tool (Gacutil.exe).
6 Answers CPCL, Syntax Softtech,
what is NET Framework ?
What is the difference between a.Equals(b) and a == b?
Name and describe some HTTP Status Codes and what they express to the requesting client ?
explain code with multi inhertance
what is webpart? what r the parts in this webpart (zone)
What are server activated objects?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)