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

Mark Tabor

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 )

3 Replies

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

Salman Beg6y ago
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/
0
Mark Tabor6y ago
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 })


}
0
Salman Beg6y ago
Hi. In this case you need to join two tables by userid and retrieve username and you need to bind it. Thanks.
0

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

Index