Answer Posted / 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 asp.net free?

993

---

What is the web.config file in asp?

1164

---

How to use multiple scriptmanager controls in a web page?

1103

---

What are the advantages and limitations of query string?

1052

---

Explain the server control events of asp.net ?

998

---

What is asp.net with mvc? : Asp.Net MVC

985

---

Can I stream live content/events?

1073

---

What is state management in .net?

1070

---

What is inproc mode in session?

942

---

Dataset is the disconnected environment. suppose if you are binding records to gridview (disconnected environment) and you are making changes to the the grid but before updating the database if any other user modify the data, how will you avoid such problem?

2153

---

Where web.config file is used?

1095

---

Who can consume WebAPI?

1013

---

What is the postback property in asp.net?

989

---

How can you debug your.net application?

1011

---

Why asp.net is better than php?

977

---