How can i implement a database search using MVC project with stored procedure.
This is my storedprocedure which i want to use to search names from the database an automatically populate the gridview is ajax code.
please help how can i go about this in ASP.Net MVC
ALTER PROCEDURE [dbo].[nameschsearch](@s as nvarchar(50)) AS
SELECT * from student
WHERE ([Name] LIKE @s or [Name] LIKE '%'+@s+'%' or [Name] LIKE '%' + @s or [Name] LIKE @s + '%' AND ((student.Status) Is Null))
ORDER BY [Name]