Asp.net MVC . How to display name instead of ID in view page

Francesco Bigi

Hello People!
I don't know how to show the the name instead of the ID

As you can see on the sub category, it is showing me the id result instead of the.
I have a table related with another table, on my sql db.
I made a connection string to my MVC project.
These are my codes:

Models -> ArticleModels.cs

public class ArticleModels
{
public int ART_Id { get; set; }
[Display(Name = "Sous Categorie")]
public int ART_SCAT_Id { get; set; }
[Display(Name = "Libelle")]
public string ART_Libelle { get; set; }
[Display(Name = "Description")]
public string ART_Description { get; set; }
[Display(Name="Prix")]
public decimal ART_Prix { get; set; }
[Display(Name = "Stock")]
public int ART_Stock { get; set; }
}

DAL -> ArticleBL.cs

public static List SelectAllArticle()
{
var rtn = new List();
using (var context = new WebShopEntities())
{
// ReSharper disable once LoopCanBeConvertedToQuery
foreach (var item in context.Article)
{
rtn.Add(new ArticleModels
{
ART_Id = item.ART_Id,
ART_SCAT_Id = item.ART_SCAT_Id,
ART_Libelle = item.ART_Libelle,
ART_Description = item.ART_Description,
ART_Prix = item.ART_Prix,
ART_Stock = item.ART_Stock
});
}
}
return rtn;
}

Controllers -> ArticleControllers.cs

public ActionResult Index()
{
var lstClient = ArticleBL.SelectAllArticle().ToList();
return View(lstClient);
}

Views -> Article -> Index.cshtml

@foreach (var item in Model)
{
<tr>
<td>
@Html.DisplayFor(modelItem => item.ART_SCAT_Id)
td>
<td>
@Html.DisplayFor(modelItem => item.ART_Libelle)
td>
<td>
@Html.DisplayFor(modelItem => item.ART_Description)
td>
<td>
@Html.DisplayFor(modelItem => item.ART_Prix)
<span class="glyphicon glyphicon-eur">span>
td>
<td>
@Html.DisplayFor(modelItem => item.ART_Stock)
td>
<td>
@Html.ActionLink("Details", "Details", new { id=item.ART_Id }) |
@Html.ActionLink("Buy", "Edit", null, new {@class = "btn btn-warning glyphicon glyphicon-shopping-cart"})
td>
tr>
}

These are my tables:

6 Replies

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

Francesco Bigi9y ago
@Catcher Wong , thank you for you help!!

I have done this, and it seem it is working:
var lstArt = new List();
            using (var ctx = new WebShopEntities1())
            {
                lstArt = ctx.Article.Select(a => new ArticleModels()
                {
                    ART_Id = a.ART_Id,
                    ART_SCAT_Id = a.ART_Stock,
                    ART_Libelle = a.ART_Libelle,
                    ART_Description = a.ART_Description,
                    ART_Prix = a.ART_Prix,
                    ART_Stock = a.ART_Stock,
                    SCAT_Libelle = a.SousCategorie.SCAT_Libelle
                }).ToList();

            }
            return lstArt;
public class ArticleModels
    {
        public int ART_Id { get; set; }
        public int ART_SCAT_Id { get; set; }
        [Display(Name = "Libelle")]
        public string ART_Libelle { get; set; }
        [Display(Name = "Description")]
        public string ART_Description { get; set; }
        [Display(Name = "Prix")]
        public decimal ART_Prix { get; set; }
        [Display(Name = "Stock")]
        public int ART_Stock { get; set; }
        [Display(Name = "Sous Categorie")]
        public string SCAT_Libelle { get; set; }
    }
0
Catcher Wong9y ago
@Francesco
You can do this to add required attributes !!

This code generate by Entity Framework:
//------------------------------------------------------------------------------
//
//    This code was generated from a template.
//
//    Manual changes to this file may cause unexpected behavior in your application.
//    Manual changes to this file will be overwritten if the code is regenerated.
//
//------------------------------------------------------------------------------

namespace XXX.Entity
{
    using System;
    using System.Collections.Generic;

    public partial class News
    {
        public int NId { get; set; }
        public string NTitle { get; set; }
        public string NContent { get; set; }
        public string NPicUrl { get; set; }
        public System.DateTime NTime { get; set; }
        public bool IsDel { get; set; }
    }
}
Add a class to add you required attributes
using System;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;

namespace XXX.Entity
{
    [MetadataType(typeof(News_Validate))]
    public partial class News
    {
    }

    public class News_Validate
    {
        public int NId
        {
            get;
            set;
        }

        [DisplayName("Title")]
        [Required(ErrorMessage = "could not be empty!")]
        public string NTitle
        {
            get;
            set;
        }

        [DisplayName("Content")]
        [Required(ErrorMessage = "could not be empty")]
        public string NContent
        {
            get;
            set;
        }

        [DisplayName("Image Url")]
        public string NPicUrl
        {
            get;
            set;
        }

        [DataType(DataType.DateTime)]
        public DateTime NTime
        {
            get;
            set;
        }

        public bool IsDel
        {
            get;
            set;
        }
    }
}
0
Francesco Bigi9y ago
@Catcher Wong
Yes I am using EF.
But I show you my map:

As you can see on the image,
I have created a folder DALEF, where I have my connection, with my db.
On my Models folder I have created my personalize class, in order to give required attributes.
And I have created a folder called DAL where I created the class where it says that my model class property are the same as the db properties.

0
Catcher Wong9y ago
@Francesco

Are you use Entity Framework?
0
Francesco Bigi9y ago
Hello @Catcher Wong
How can I do on my example, because on that way , you are contacting to your db.
I have created my own class which refers to my db.
And I don't know how to include, when I do the scaffolding, I can see your example that works fine, but without scaffolding how to do?
0
Catcher Wong9y ago
Hi Francesco ,

You can follow the MVC MusicStore project !!

In model class :
   [Bind(Exclude = "AlbumId")]
   public class Album
   {
       [ScaffoldColumn(false)]
       public int AlbumId { get; set; }

       [DisplayName("Genre")]
       public int GenreId { get; set; }

       [DisplayName("Artist")]
       public int ArtistId { get; set; }

       [Required(ErrorMessage = "An Album Title is required")]
       [StringLength(160)]
       public string Title { get; set; }

       [Required(ErrorMessage = "Price is required")]
       [Range(0.01, 100.00,
           ErrorMessage = "Price must be between 0.01 and 100.00")]
       public decimal Price { get; set; }

       [DisplayName("Album Art URL")]
       [StringLength(1024)]
       public string AlbumArtUrl { get; set; }

       public virtual Genre Genre { get; set; }
       public virtual Artist Artist { get; set; }
       public virtual List OrderDetails { get; set; }
   }
Get the Data
private MusicStoreEntities db = new MusicStoreEntities();

//
// GET: /StoreManager/
public ViewResult Index()
{
     var albums = db.Albums.Include(a => a.Genre).Include(a => a.Artist);
     return View(albums.ToList());
}
View to Show
@foreach (var item in Model) {
   <tr>
       <td>
           @Html.DisplayFor(modelItem => item.Genre.Name)
       td>

   tr>
}
The link of the project :

http://mvcmusicstore.codeplex.com/SourceControl/latest
0

Asp.net MVC . How to display name instead of ID in view page

@Catcher Wong