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

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...

Explain the components of web form in asp.net

0 Answers  

---

What is web api vs wcf?

0 Answers  

---

Why will you usually create an aspnet user account in the database for an asp.net web application?

0 Answers  

---

Where would you use an ihttpmodule, and what are the limitations if any?

0 Answers  

---

Is redux flux?

0 Answers  

---

Explain transparent caching with aop?

0 Answers  

---

what is Repeater Control, When it is used,How it is used, what type of template is used for repeater control?

6 Answers   iSoft,

---

How would you get ASP.NET running in Apache web servers - why would you even do this?

1 Answers   Siebel Systems,

---

How to do parallel database export in remote SQL Server in ESSL time track. It is working for local server but not working for remote SQL Server

0 Answers   CTPL,

---

What does asp in asp.net stand for?

0 Answers  

---

Explain the concept of MVC Scaffolding?

0 Answers   B-Ways TecnoSoft,

---

Which control would you use if you needed to make sure the values in two different controls matched?

2 Answers  

---