MVC4 Razor( How To get a specific value from database

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))

{

@Html.TextBoxFor(Model=>Model.UserName)

@Html.DisplayFor(Model=>Model.RollId)

}

----------------------------------------------------------------------------------------------------------------------------

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..:)

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jinish Gandhi10y ago
Thnkx its working:)
Ravi Patel10y ago
Hi ,

try this

[HttpPost]
public ActionResult GetResult(EmpInfo_Tbl ET)
{
using (db)
{
var v = db.EmpInfo_Tbl.Where(u => u.UserName== ET.UserName).FirstOrDefault();
if(v==null)
{
ViewBag.RollId = " role id not found";
}

ViewBag.RollId = v.RollId.ToString();
}
return View(ET);
}

and put @ViewBag.RollId in your view page
Dorababu Meka10y ago
Try this way var v = db.EmpInfo_Tbl.Where(u => u.UserName.Equals(ET.UserName)).FirstOrDefault(); ViewBag.RollId = v.RollId;