How to pass collection variable (var result) values from Controller to View in MVC5

Question

0.00/5 (No votes)

See more:

Hi,
Please provide any solution. Below is the scenario:

Controller

public ActionResult Category(int id)
 {
  var result = db.Categories.Where(s => s.DepartmentId == id).Select(x => new  { id = x.CategoryId, name = x.CategoryName }).ToList();       
   return View(result);
}

View

@model IEnumerable<kshoppingcart.models.category>

Model

namespace KShoppingCart.Models
{
    using System;
    using System.Collections.Generic;

    public partial class Category
    {
        public Category()
        {
            this.SubCategories = new HashSet<SubCategory>();
        }

        public Nullable<int> DepartmentId { get; set; }
        public int CategoryId { get; set; }
        public string CategoryName { get; set; }

        public virtual Department Department { get; set; }
        public virtual ICollection<SubCategory> SubCategories { get; set; }
    }
}

Ex: Here I can get count=2 with values in variable result. But how can I display these values using View.

Thanks
JSagar

Posted 1-Jan-15 0:05am

jsagar05

Updated 1-Jan-15 0:20am

Abhishek Pant

v3

Add a Solution

Comments

[no name] 2-Jan-15 2:44am

Hello Sagar,
The problem here is you are selecting the ID and Name in the LINQ. Please remove the select statement. Just use where(condition).ToList();
Please check using this and then follow as mentioned in the solution.

jsagar05 2-Jan-15 5:37am

Hi Suraj,
As per your suggestion I removed select statement and it worked.
Thanks a lot

2 solutions

Solution 2

In view You can wright follwing code

HTML

<table>
<tr>
<th> Category Name </th>
<th> Department </th>
<th> More (can be blank) </th>
</tr>

@if(Model!=null)
{

HTML

<pre lang="c#">

foreach(catItem in Model)
{
<tr>
<Th> @catItem.CategoryName </Th>
<Th> @catItem.Department </Th>
<Th> Link for expend collapse </Th>

if(catItem.SubCategories!=null)
{
foreach(subcatItem in catItem.SubCategories)
{
<tr>
<Th> col name </Th>
........
}
}

</Tr>
}
}

HTML

Posted 1-Jan-15 1:04am

Manoj Kumar Choubey

Updated 1-Jan-15 1:06am

v2

Comments

jsagar05 2-Jan-15 2:33am

Actually in my View I am passing:
@model IList<kshoppingcart.models.category>

but I am getting below error:

The model item passed into the dictionary is of type 'System.Collections.Generic.List`1[<>f__AnonymousType3`2[System.Int32,System.String]]', but this dictionary requires a model item of type 'System.Collections.Generic.IList`1[KShoppingCart.Models.Category]'.

Please refer my above code also.

Thanks

Manoj Kumar Choubey 2-Jan-15 3:14am

You should create view model.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suraj Sahoo | Coding Passion · Accepted Answer · 2015-01-01T00:54:00

Solution 1

Use

C#

@foreach(var item in Model.SubCategories)
{
    <span>@item.XYZ</span>
    //...Continues.. for other properties.
}

I hope I have anticipated correct.
Please post back queries if any.
thanks.:)

Posted 1-Jan-15 0:54am

Suraj Sahoo | Coding Passion

Updated 1-Jan-15 1:24am

v2

Comments

Sanket Saxena 1-Jan-15 7:04am

Should work :)