Home / Questions / 72840
Accepted
Javier fr
Asked: 2020-05-25 11:47:40 +0800 CST 2020-05-25 11:47:40 +0800 CST

How to pass data that is in the DB through the controller to the view?

  • 772

Method (Data) of my Controller:

// GET: datos
    public ActionResult Datos()
    {
        var datos = db.alumno.Include(a => a.grupo);
        ViewBag.mensaje = "HOLA MUNDO";

        var query = from Alumno in db.alumno
                    join Grupo in db.grupo on Alumno.id_alumno equals Grupo.id_alumno
                    select new { alumno = Alumno, grupo = Grupo };

        return View(query); 

    }

View where the data should be displayed

@model IEnumerable<WebApplication1.grupo>
@{
    Layout = null;
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Datos</title>
</head>
<body>
    <div> 

        @foreach (var item in Model)
        {
            @item.id_grupo <br />
        }

        @ViewBag.mensaje
    </div>
</body>
</html>

c#

2 Answers

  1. Best Answer

    Your variable datosis a list or collection of objects of the type Alumno, what you should do is:

    var datos = db.alumno.Include(a => a.grupo);
return View(datos);

    And in your View:

    @model IEnumerable<Project.Models.Alumno>

    To cycle through them:

    @foreach (var item in Model) {
    //item.Nombre
    //etc
}

    EDITION

    Regarding the fact that you changed the query, I help you

    Since now you don't return a list of a specific object but a list with JOIN. You must do the following:

    create a MODEL

    public class AlumnoGrupo
{
    public string AlumnoNombre { get; set; }
    public string GrupoNombre { get; set; }
    public int GrupoId { get; set; }
}

    Then in your Controller :

    List<AlumnoGrupo> model = new List<AlumnoGrupo>();
var result = from a in db.alumno join g in db.grupo on a.id_alumno equals g.id_alumno
             select new AlumnoGrupo()
             { 
                AlumnoNombre = a.Nombre,
                GrupoNombre = g.Nombre,
                GrupoId = g.Id
             }
model = result.ToList();
return View(model);

    In this Join code block, we create our object with the attributes we need, I made those fields to give you an example and also because I don't know the data you need.

    And finally in your View

    @model IEnumerable<Project.Models.AlumnoGrupo>

@foreach (var item in Model)
{
    @item.GrupoId <br />
}
    • 4

  2. Update your code as follows:

    Controller

    // GET: datos
public ActionResult Datos()
{
    var datos = db.alumno.Include(a => a.grupo);
    ViewBag.mensaje = "HOLA MUNDO";
    return View(datos);
}

    View (in case it datosis not a collection)

    @model MiProyecto.Alumno      
@{

    Layout = null;
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Datos</title>
</head>
<body>
    <div> 
        @Html.TextBoxFor(m => m.Nombre)
        @ViewBag.mensaje
    </div>
</body>
</html>

    View (in case it datosis a collection)

    @model IEnumerable<MiProyecto.Alumno>      
@{

    Layout = null;
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Datos</title>
</head>
<body>
    <div> 
        @foreach (var item in Model)
        {
             @item.Nombre <br/>
        }
        @ViewBag.mensaje
    </div>
</body>
</html>
    • 3