Model public class Users { public string Name { get; set; } public string Email { get; set; } } View @using (Html.BeginForm("Contact", "Home")) { <input id="Text1" type="text" name="txtOne" /> <input id="Button1" type="submit" value="button" /> } Controller [HttpPost] public ActionResult Contact() { string textboxValue = Request.Form["txtOne"]; var result = db.Database.SqlQuery<Users>("usp_searchuser, @UserInput", new SqlParameter("@UserInput", textboxValue)); return View(result); }
CREATE procedure usp_searchuser --'Sara Nani' @UserInput varchar(50) As Begin select Email,Name from tblEmployee where Name = @UserInput End
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)