how to show user name instead of user id from another table

Question

Hi I am saving the master records Like say for example i am saving Fruits names into the database , my table is having columns ( fruitId,Name,AddBy(this field is saving using Session("UserID")) My User Table is a separate table where i have userID as well as its user name , Now on Fruit listing view i am showing fruit ID,Name,Add BY ( instead of UserID i want to show user name against this user Id from User Table how to achieve that )

Salman Beg · Answer

In the index action method, instead of simply returning list you need to join two tables by using linq and get the result. You can follow this link which showed an example, https://www.c-sharpcorner.com/article/asp-net-mvc-webgrid-with-crud-record-from-two-tables-and-custom-search-functiona/

Mark Tabor · Answer

Here is my models User Model class { public int userID{ get ; set ;} public string Name{ get ; set ;} } here is my fruit model class public class fruit { public int id{ get ; set ;} public string fruitName{ get ; set ;} public int Added_by{ get ; set ;} (here user id is coming) from session i am stroing it } my Index controller public ActionResult Index() { return View(db.fruit.ToList()); } My View is @model IEnumerable @{ ViewBag.Title = "Index" ; Layout = "~/Views/Shared/_Layout2.cshtml" ; } Index @Html.ActionLink( "Create New" , "Create" ) class = "table" > @Html.DisplayNameFor(model => model.Fruit_Name) @Html.DisplayNameFor(model=>model.Added_By) @ foreach (var item in Model) { @Html.DisplayFor(modelItem => item.fruit_Name) @Html.DisplayFor(modelItem => item.Added_BY) Here i need user Name ? @Html.ActionLink( "Edit" , "Edit" , new { id=item.Id }) | @Html.ActionLink( "Details" , "Details" , new { id=item.Id }) | @Html.ActionLink( "Delete" , "Delete" , new { id=item.Id }) }

Salman Beg · Answer

Hi. In this case you need to join two tables by userid and retrieve username and you need to bind it. Thanks.