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 dataset and uses of dataset ?

6 Answers   HCL, TCS,

---

One of the properties of the Web Part has an incorrect format. Windows SharePoint Services cannot deserialize the Web Part. Check the format of the properties and try again. - this error is occured in Sharepoint 2007 while deploy the web part

1 Answers   WebInfo,

---

What is the purpose of asp.net?

0 Answers  

---

What is the difference between user control and custom control?

0 Answers  

---

How can you change a Master page dynamically in which event of page life cycle?

2 Answers   Fulcrum Logic,

---

Can one dll file contains the compiled code of more than one .net language?

0 Answers  

---

What do you understand from custom control?

0 Answers   C DAC, CDAC,

---

Which methods validate all the controls on a page?

0 Answers  

---

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

0 Answers  

---

Explain the significance of routing? : asp.net mvc

0 Answers  

---

what are the events raised in asp.net page life cycle?in which stage view state can be loaded?

0 Answers   EDS,

---

Explain the difference between asp.net mvc and asp.net webforms? : asp.net mvc

0 Answers  

---