Displaying a Table of Database Data

thanks....

Trying to follow along with your vb code in C#.  When I run the app for the first time, I get

Line 13: <% foreach (Call c in ViewData.Model)%>

CS1579: foreach statement cannot operate on variables of type 'object' because 'object' does not contain a public definition for 'GetEnumerator'

I've tried to remove my dbml and re-create it following your pattern.  I have a Calls table that I have dropped onto my Call model.

Not sure if there's a difference between C# and VB that's biting me here, or if I'm simply missing a step.

Good video overall... high quality video and audio, good presentation.

@sn33zingpanda -- Yes, this is a difference between C# and VB.NET. In C#, you must explicitly cast ViewData.Model to an IEnumerable in your foreach loop:

<% foreach (var c in (IEnumerable)ViewData.Model) { %>

The other option is to use a strongly typed view. When you create a strongly-typed view, you specify the type of the ViewData.Model property in your code-behind class.

Stephen You rock.

I am trying to add a Mvc View user control as shown in the video but the code in the Index.aspx page is failing on the RenderUserControl line.

<% foreach (Project p in (IEnumerable)ViewData.Model)

  { %>

       <%= Html.RenderUserControl (ViewData.Model, "~/Views/Home/ProjectTemplate.ascx", p); %>

<% } %>

The error message is 'System.Web.Mvc.HtmlHelper' does not contain a definition for 'RenderUserControl' and no extension method 'RenderUserControl' acceptin a first argument of type 'System.Web.Mvc.HtmlHelper' could be found.

I have the following in the Index.aspx.cs:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

using MvcCorporate.Models;

namespace MvcCorporate.Views.Home

{

   public partial class Index : ViewPage

   {

   }

}

How do I get access to the RenderUserControl?

How about displaying 2 tables in the View.

Let say we want to display 2 different LinkToSql Queries (Top 5 New Releases and Movies directed by  Steven Spielberg)

How we do that if return View on the Controller only accepts one Model object?

Francisco

Thank you! I'm even going to overlook that "Star Wars II" mistake you did in the movie table :P Good work on the videos, they rock!

Preview 5 is now using Html.RenderPartial instead of RenderUserControl

Another very great series.  This really helps those new to MVC, makes it quick to pick up.

Microsoft definitely ought to provide video series of this quality together for every major technology.  However, is anyone else hearing creepy bubbles and noises in the background (11:24)?

Hi everyone, hope i can get some help on this, and I have a gut feeling that this will be considered as an extremely stupid question, but i'm also a REAL noob when it comes to .Net.

I've looked at a lot of the tutorial videos, which are amazing btw, and i can follow along quite nicely.

I tried a simple Mvc application using Linq2SQL and C#.

I'm getting an "InvalidCastException was unhandled by user code" error when i try to display my client table the same as in the video (except i'm doing it in C#).

this is my code.

AdminController:

       public ActionResult ClientList()

       {

           myDataContext dataContext = new myDataContext();

           var client = from c in dataContext.Clients   select c;

 return View(client);

}

clientList.aspx:

<%@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/Site.Master" AutoEventWireup="true" CodeBehind="ClientList.aspx.cs" Inherits="cbia.Views.Admin.ClientList" %>

<%@ Import Namespace="MvcApplication1.Models" %>

   <tr>

       <td>test data</td>

   </tr>

       <%            

           foreach (Client c in (IEnumerable)ViewData.Model)

           {

       %>

       <tr>

           <td>

               <%= c.name%>

           </td>

           <td>

               <%= c.address%>

           </td>

           <td>

               <%= c.isActive%>

           </td>

       </tr>

       <% } %>

   </table>

</asp:Content>

I would appreciate any guidance in this matter!