Passing Data from Controllers to Views

Question

I have spent the past day and a half trying to find this answer and sometimes it seems like I am so close but so far no luck. I have a controller where I defined a LINQ query and am trying to figure out how to pass the results onto a listing view. the following is the Controller code:

namespace CMS.Controllers
{
    public class SurveyController : Controller
    {

        private SupportEntities supdb = new SupportEntities();
        private BuisnessEntities bsdb = new BuisnessEntities();

        //
        // GET: /Survey/BizSurveyC

        public ViewResult BizSurveyC(string nipaKey, string bOrg)
        {
            // use the next two lines for testing and then either delete or comment them out.
            nipaKey = "22";
            bOrg = "MPC";

            var Cquery = from Mstr in bsdb.BizOrgInsts
                                     join Dat in bsdb.BizSurveyQ on Mstr.ID equals Dat.MASTERID
                                     where Mstr.NIPAKEY == nipaKey & Mstr.FULCIRCORG == bOrg
                                     orderby Mstr.STREETSUFX, Dat.ADDRESS, Mstr.NUMBER
                                     select new { MasterId = Mstr.ID, Name = Mstr.OLDNAME, Mstr.ADDRESS, Mstr.NIPAKEY, Dat.SURVEYDATE, SurveyId = Dat.ID, Dat.RESURVEYOF, Dat.STAMP };

            //ViewBag.BizQuery = Cquery;
            ViewData["BizQuery"] = new SelectList(Cquery);

            return View();
        }

    }
}

As you can tell by looking I have tried ViewData and Viewbag but so far with no luck

Here are the way things are now appearing:

ViewModel Class

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace CMS.Models
{
    public class BizSurveyCVM
    {
        public long? MasterId { get; set; }
        public string Name { get; set; }
        public string Address { get; set; }
        public string NipaKey { get; set; }
        public string Date { get; set; }
        public long? SurveyId { get; set; }
        public long? Resurvey { get; set; }
        public string DateStamp { get; set; }
    }
}

Modified Action

        var Cquery = (from Mstr in bsdb.BizOrgInsts
                                    join Dat in bsdb.BizSurveyQ on Mstr.ID equals Dat.MASTERID
                                    where Mstr.NIPAKEY == nipaKey & Mstr.FULCIRCORG == bOrg
                                    orderby Mstr.STREETSUFX, Dat.ADDRESS, Mstr.NUMBER
                                    select new BizSurveyCVM
                                    {
                                        MasterId = Mstr.ID,
                                        Name = Mstr.OLDNAME,
                                        Address = Mstr.ADDRESS,
                                        NipaKey = Mstr.NIPAKEY,
                                        Date = Dat.SURVEYDATE,
                                        SurveyId = Dat.ID,
                                        Resurvey = Dat.RESURVEYOF,
                                        DateStamp = Dat.STAMP
                                    }).ToList();

        return View(Cquery);
    }

BizSurveyC View

@model List<CMS.Models.BizSurveyCVM>

<table>
    <tr>
        <th>
            MasterId
        </th>
        <th>
            Name
        </th>
        <th>
            Address
        </th>
        <th>
            NipaKey
        </th>
        <th>
            Date
        </th>
        <th>
            SurveyId
        </th>
        <th>
            Resurvey
        </th>
        <th>
            DateStamp
        </th>
        <th></th>
    </tr>

@foreach (var item in Model) {
    <tr>
        <td>
            @Html.DisplayFor(modelItem => item.MasterId)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.Name)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.Address)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.NipaKey)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.Date)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.SurveyId)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.Resurvey)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.DateStamp)
        </td>
</table>

here is the resulting view:

SORRY NOT ALLOWED TO SAVE IMAGE YET BUT IN THE VIEW I HAVE HEADERS BUT NO DATA.

I obviously have some work to do in the view or maybe the query but things are looking much better thanks so everyone's help. Thank you very much

What you have so far is fine so I suspect the issue is how you are calling viewdata in the view. — Brian
– Brian, Commented May 31, 2012 at 14:11
This is MVC 3 and as far as a view goes I haven't had any successful attempts so far so there currently isn't anything. — Richard K
– Richard K, Commented May 31, 2012 at 14:15
@RichardK - I've updated my answer to show a way of rendering the view with the ViewModel. — CAbbott
– CAbbott, Commented Jun 1, 2012 at 15:51

CAbbott · Accepted Answer · 2012-06-01 15:50:09Z

2

You could create a ViewModel class to hold whatever your query results are and then strongly type your view for the new ViewModel class:

ViewModel Class:

public class BizSurveyCVM 
{
    public long MasterId { get; set; }
    public string Name { get; set; }
    ...
}

Modified Action:

var Cquery = (from Mstr in bsdb.BizOrgInsts
              join Dat in bsdb.BizSurveyQ on Mstr.ID equals Dat.MASTERID
              where Mstr.NIPAKEY == nipaKey & Mstr.FULCIRCORG == bOrg
              orderby Mstr.STREETSUFX, Dat.ADDRESS, Mstr.NUMBER
              select new BizSurveyCVM  { MasterId = Mstr.ID, Name = Mstr.OLDNAME, ...}
             ).ToList();

return View(Cquery);

BizSurveyC View

@model List<{namespace}.BizSurveyCVM>

@foreach(var item in Model) {
     {HTML Mark-up}
}

EDIT: Here's an updated example of the view based on the updated question:

@model List<{namespace}.BizSurveyCVM>

@foreach(var item in Model) {
    <tr>
        <td>
            @item.MasterId
        </td>
        <td>
            @item.Name
        </td>
        <td>
            @item.Address
        </td>
        ...
    </tr>
}

edited Jun 1, 2012 at 15:50

answered May 31, 2012 at 14:42

CAbbott

8,1184 gold badges33 silver badges39 bronze badges

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

7 Comments

Phillip Schmidt Over a year ago

This is probably a better solution than mine if you'll be using that kind of model more than once. If you're just using it once, this is probably a little bit of overkill.

Richard K Over a year ago

I like this one and am trying it now. This is more familiar to me. I will let everyone know how it turns out.

Richard K Over a year ago

I have the modified code finished but I am unable to post it because of formatingI will read the help and see if I can figure it out. Also it is still not working. I am getting the following error message: The model item passed into the dictionary is of type 'System.Collections.Generic.List1[<>f__AnonymousType48[System.Nullable1[System.Int64],System.String,System.String,System.String,System.String,System.Nullable1[System.Int64],System.Nullable1[System.Int64],System.String]]', but this dictionary requires a model item of type 'System.Collections.Generic.List1[CMS.Models.BizSurveyCVM]'.

CAbbott Over a year ago

It sounds like you're not doing the select new BizSurveyCVM within your Linq statement.

Richard K Over a year ago

LINQ STATEMENT: var Cquery = (from Mstr in bsdb.BizOrgInsts join Dat in bsdb.BizSurveyQ on Mstr.ID equals Dat.MASTERID where Mstr.NIPAKEY == nipaKey & Mstr.FULCIRCORG == bOrg orderby Mstr.STREETSUFX, Dat.ADDRESS, Mstr.NUMBER select new { MasterId = Mstr.ID, Name = Mstr.OLDNAME, Address = Mstr.ADDRESS, NipaKey = Mstr.NIPAKEY, Date = Dat.SURVEYDATE, SurveyId = Dat.ID, Resurvey = Dat.RESURVEYOF, DateStamp = Dat.STAMP }).ToList();

|

Phillip Schmidt · Accepted Answer · 2012-05-31 14:09:15Z

0

return View(Cquery);

or

return View("ViewName",Cquery);

and then in your view, the model type should match the type of Cquery. But I find that its easier (assuming you're using VS) to just right click in the method body somewhere and click "add view", and select the model from the list of model types.

answered May 31, 2012 at 14:09

Phillip Schmidt

8,8283 gold badges45 silver badges67 bronze badges

2 Comments

Richard K Over a year ago

Since this is a join what model type would you use or should the join somehow be a model?

Phillip Schmidt Over a year ago

maybe a linked list or dictionary? You can pretty much use whatever type you want, so long as you handle the conversion first. If you wanted to do the dictionary route, youd loop through the join and build a Dictionary<something, something> out of it. Then pass the dictionary to the view and have the view accept dictionaries

Zach dev · Accepted Answer · 2012-05-31 15:07:14Z

0

Are you sure that you want do?

it's more useful the collection in the view, so you can build anything you need, like a select list.

don't forget define who is your datavalue and displayvalue in the select list, like..

ViewData["BizQuery"] = new SelectList(Cquery, null, "MasterId", "Name");

Ok, your code works for me, so check your view, you must do the correct cast of your object in the viewdata

you need have something like this

@foreach (SelectListItem item in (SelectList)ViewData["BizQuery"])
{

    <p>@item.Text</p>

}

edited May 31, 2012 at 15:07

answered May 31, 2012 at 14:42

Zach dev

1,6208 silver badges15 bronze badges

Collectives™ on Stack Overflow

Passing Data from Controllers to Views

3 Answers 3

7 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related