c# - trying to access data from Model in view page. .Net Mvc4 -
i have class in model
namespace foreclosure.models { public class foreclosurelist { public string area { get; set; } public int numberoflistings { get; set; } } public class rets_listingsmodel { public rets_listingsmodel(){} // empty constructor public static ienumerable<foreclosurelist> getforeclosurelist() // making ienumerable list contain forclosure data { sqlconnection myconn; sqlcommand mycmd; sqldatareader myreader; system.collections.arraylist aforclosurelist = new system.collections.arraylist(); // create array hold data, later converted ienumerable list. string mysql = "select [area], count (*) numberlistings rets_listings_full" + " foreclosureyn = 'y'" + " , area <> ''" + " group area"; myconn = new sqlconnection(configurationmanager.appsettings["connectionstring"]); mycmd = myconn.createcommand(); mycmd.commandtext = mysql; myconn.open(); myreader = mycmd.executereader(); while (myreader.read()) { foreclosurelist currentlist = new foreclosurelist(); // making instance foreclosurelist class , adding results query. currentlist.area = (string)myreader["area"]; currentlist.numberoflistings = (int)myreader["numberlistings"]; aforclosurelist.add(currentlist); // adding class object array } myreader.close(); myconn.close(); ienumerable<foreclosurelist> iforeclosurelist = aforclosurelist.cast<foreclosurelist>(); //converting array ienumerable list return iforeclosurelist; } } } and on view page have
<%@ page language="c#" masterpagefile="~/views/shared/site.master" inherits="system.web.mvc.viewpage<foreclosure.models.foreclosurelist>" %> and code dispaly list is
<ul> <% foreach ( var moo in model) { %> <li><%: moo.area %></li> <% } %> </ul> but getting error : cs1579: foreach statement cannot operate on variables of type 'foreclosure.models.foreclosurelist' because 'foreclosure.models.foreclosurelist' not contain public definition 'getenumerator'
but getting error : cs1579: foreach statement cannot operate on variables of type 'foreclosure.models.foreclosurelist' because 'foreclosure.models.foreclosurelist' not contain public definition 'getenumerator'
try this:
<%@ page language="c#" masterpagefile="~/views/shared/site.master" inherits="system.web.mvc.viewpage<ienumerable<foreclosure.models.foreclosurelist>>" %
Comments
Post a Comment