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

what is the advantage of data reader?

2 Answers  

---

What is paging in context of Memory?

0 Answers   Microsoft,

---

What is the main function of razor in asp.net? : asp.net mvc

1 Answers  

---

what is state management,what is the purpose of it,how it will be implemented in real time?

2 Answers  

---

What is ispostback method in asp.net? Why do we use that?

0 Answers  

---

Can you create an app domain ?

1 Answers  

---

What is Cookies Less Session?

0 Answers  

---

Why does my asp.net file have multiple tag with runat=server?

0 Answers  

---

Which data types are supported by the RangeValidator control?

2 Answers   Siebel,

---

how many character send in one sms forget 160limit and think about gateway allowed

2 Answers   Wipro,

---

To add a hyperlink column to the DataGrid which tag is used ?

0 Answers   Siebel,

---

What are typed datasets?

1 Answers   IBS,

---