search bar in ASP.NET

Srinivas Rao

10y995Learn iOS Programming

hai friends,

these are the two textboxes "EmpId" in Textbox1,and another for "Employee name. in Textbox2"

so i want to search by "empid", by leaving second textbox as empty

at the sametime if i left "first textbox" as empty,and the second textbox with "Employee Name" .

the data should appaer in the gridview.

i had written a query like this ,but iam not getting.

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

pls reply,

In advance

thanku

2 Replies

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

Imtiyaz Ansari10y ago
Hello Srinivas

can you use COALESCE function with like

Try This query...!!

if @EmpID=''
set @EmpID=null
if @FirstName=''
set @FirstName=null
select Id,EmapID,FirstName,MI,LastName from Employee where EmpID LIKE '%' + COALESCE(@EmpID,EmpID) and FirstName LIKE '%' + COALESCE(@FirstName,FirstName)
Amit Kumar Singh10y ago
SELECT [id], [EmpId], [FirstName], [MI], [LastName] FROM [Employees] WHERE EmpId like CAST(@EmpId as varchar) + '%' OR FirstName like @FirstName + '%'