retrive data using two textboxes

Srinivas Rao

hi,i want to retrive the data from database using two textboxes by clicking on a search btn.

#.)One textbox is for "EmpId" another Textbox if for "EmpName"

#.)there is a "OR" btwn two textboxes.

#.)with the below query "iam able to retrive data from "DB" if i enter data in both textboxes.",but

## I want the query for retrivng data i.e same data from db and show in the gridview,by using the singletextbox or both textboxes .

#.)Gridview

Id EmpId FirstName MI LastName

SelectCommand="SELECT [id], [EmpId], [FirstName], [MI], [LastName] FROM [Employees] WHERE [EmpId] like CAST(@EmpId as nvarchar) + '%' OR FirstName like @FirstName + '%' "

if any are changes are required to the above query

pls reply ,

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Kumar Singh10y ago
SELECT Id,Name FROM Employee WHERE Id=@Id or Name=@Name
Srinivas Rao10y ago
thanku Amitsingh,

the query is working,only wen i enter the data in both textboxes.
if i left one textbox and enter data in the second textbox ,the gridview is not coming.
i want to rectify this problem.
Amit Kumar Singh10y ago
Hey,

Its work on basis of Id or Name

SELECT * FROM Employee WHERE Id like CAST(@Id AS VARCHAR) + '%' OR NAME like @NAME +'%'

So we Set what u want to retrieve based on this query