I have Made a webgrid with that just above that I have 3 text boxes and a button for search and beneath that their is a webgrid too.I need to make a fuctionlity when user enters anything in that text boxes 1 or text box 2 or text box 3.That Data should be shown in the webgrid in that row.I have made a store procedure and using Entity Framework in my mvc.Please Let me know guys..
create procedure usp_procsearch
(
@pass as varchar(100),
@Name as varchar(100),
@Address as varchar (100)
)
As
Begin
select id,loginiId,pass,Name,Email,[Address],age from tblLoginDetails where (pass like '%'+ @pass+'%'or
Name like '%'+ @Name+'%'or
[Address] like '%'+ @Address+'%')
End