how to display all the data from database in MVC5 views

Question

  public class EmployeeController : Controller
{
    //
    // GET: /Employee/

    public ActionResult Details(int id)
    {
        EmployeeContext employeeContext = new EmployeeContext();

        Employee employee = employeeContext.Employees.SingleOrDefault(x => x.EmployeeId == id);
        return View(employee);
    }

}

//here i am getting only one row with respect to id .. how can i get the whole rows from the table ?and how can i view that on the view page?

so you want all rows in your table to be displayed on another page? like the Index.cshtml page? — Grizzly
– Grizzly, Commented Mar 24, 2016 at 13:10

Nick Larsen · Accepted Answer · 2016-03-24 13:23:20Z

2

To return the whole table, just select the whole table instead of filtering.

Employee[] allEmployees = employeeContext.Employees.ToArray();

To show them in a view, just have the model type for your view be an array instead of just a singular Employee. Basically just make the model Employee[]. Then you can just loop over the model.

@model Employee[]
@foreach(var employee in Model)
{
    // do something interesting
}

answered Mar 24, 2016 at 13:23

Nick Larsen

18.9k6 gold badges70 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to display all the data from database in MVC5 views

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related