retrive data using two textboxes

Question

hii 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 gridviewby using the singletextbox or both textboxes . #.)Gridview Id EmpId FirstName MI LastNam e 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

Amit Singh · Answer

SELECT IdName FROM Employee WHERE Id=@Id or Name=@Name

Srinivas Rao · Answer

thanku Amitsingh the query is workingonly 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 Singh · Answer

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