i am using entity data model in mvc 4,i want specific value from dabase like as(select username from Emp where RollId="Textbox1.text")
but in mvc code
______________________________________________________________________
1.[view file code]-->GetResultView
@using(Html.BeginForm("GetResult","Login",FormMethod.Post))
{
<div>
@Html.TextBoxFor(Model=>Model.UserName)
</div>
<div>
@Html.DisplayFor(Model=>Model.RollId)
</div>
<div>
<input type="submit" value="GetResult" name="GetResult">
</div>
}
----------------------------------------------------------------------------------------------------------------------------
2.[Controller]
public ActionResult GetResult()
{
return View();
}
[HttpPost]
public ActionResult GetResult(EmpInfo_Tbl ET)
{
using (db)
{
var v = db.EmpInfo_Tbl.Where(u => u.UserName.Equals(ET.UserName)).Select(u =>u.RollId).FirstOrDefault();
ViewBag.RollId = v.ToString();
}
return View(ET);
}
------------------------------------------------------------------------------------------------------------------------
But in all thing i get value zero...but i didnt get excatly values..so plz help me to find out..:)