Basant Gera

Basant Gera

  • NA
  • 1
  • 591

MVC asp

Feb 13 2016 1:12 PM
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..
stored Procedure:
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

Answers (1)