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 the advantage of using Windows authentication in a Web application?
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,
Describe a bubbled event and how it is used ?
Authentication and Authorization
Mention few asp.net validators.
where can i gather the materials for MCP certification
Can you explain composite pattern?
What is the good practice to implement validations in aspx page?
You create an ASP.NET application for a hotel. The application contains a page that displays current weather conditions for the city in which the hotel is located. The application calls an XML Web service every 10 minutes to update the current weather conditions. A new page is then displayed for subsequent requests. You want the same page to be cached and retrieved from the cache during the time between calls to the XML Web service. You decide to use a Page directive to accomplish this goal. Which Page directive should you use? A . <%@ Cache Seconds="600 '' VaryByParam="Page" %> B . <%@ OutputCache Time="600" %> C . <%@ OutputCache Duration="600" VaryByParam="None" %> D . <%@ OutputCache Duration="600" %>
I have a datagrid of 10 rows and I am updating the fifth row using template column edit. How wil u know that the row is updated, so that it can be send to database for updating the respective table?
step to create a strong name?
How Session use Cookies in State Management?
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)