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

Should sn.exe be used before gacutil.exe ?

2 Answers   Accenture, BirlaSoft,

---

What is considered a service provider?

0 Answers  

---

What does AspCompat="true" mean and when should I use it?

1 Answers   Infogain,

---

Can you store dataset in viewstate?

7 Answers   Microsoft,

---

What is difference between view and partial view?

0 Answers  

---

what is the dllhell? why we use the dllhell?

4 Answers  

---

What is session start?

0 Answers  

---

What is difference between ASP and ASP.NET ?

3 Answers   TCS,

---

How do you do validations. Whether client-side or server-side validations are better ?

2 Answers   InfoLinks, Microsoft,

---

can we store textbox and com components in viewstate?

4 Answers   Microsoft,

---

What is server infrastructure?

0 Answers  

---

How can you implement encapsulation in asp.net?

6 Answers   TCS,

---