My model goes like this\[code\]namespace CustomerBook.Models{ public class CustomerModels { public string fname { set; get; } public string lname { set; get; } public string city { set; get; } public List<CustomerModels> lst; public List<CustomerModels> getData() { string path = @"somepath\MvcApplication13\\Book1.xlsx"; string excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;"; OleDbConnection excelConnection = new OleDbConnection(excelConnectionString); OleDbCommand ocmd = new OleDbCommand("select * from [Sheet1$]", excelConnection); excelConnection.Open(); OleDbDataReader odr = ocmd.ExecuteReader(); lst = new List<CustomerModels>(); CustomerModels modl; while (odr.Read()) { modl = new CustomerModels(); modl.fname =valid(odr, 0); modl.lname = valid(odr, 1); modl.city = valid(odr, 2); lst.Add(modl); } excelConnection.Close(); return lst; } protected string valid(OleDbDataReader myreader, int stval) { //if any columns are found null then they are replaced by zero object val = myreader[stval]; if (object.ReferenceEquals(val, DBNull.Value)) { return Convert.ToString(0); } else { return val.ToString(); } }}\[/code\]}my controller is \[code\]using System.Linq;using System.Web;using System.Web.Mvc;using CustomerBook.Models;namespace CustomerBook.Controllers{ public class LoadCustomerAndDisplayController : Controller { // // GET: /LoadCustomerAndDisplay/ public ActionResult Index() { CustomerModels objCustomer = new CustomerModels(); var dataval = objCustomer.getData(); return View(dataval); } }}\[/code\]the view generated is \[code\]<%@ Page Language="C#" Inherits="System.Web.Mvc.ViewPage<CustomerBook.Models.CustomerModels>" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title>Index</title></head><body> <div> hhiiiiiiiiiiiiii<br /> <%=Model.fname %> <%=Model.lname %> <%=Model.city %> </div></body></html>\[/code\]the problem is that\[code\]<%=Model.fname %> <%=Model.lname %> <%=Model.city %>\[/code\]is not giving me any output...i check dataval value by debuging...its holding the value.........error isThe model item passed into the dictionary is of type 'System.Collections.Generic.List`1[CustomerBook.Models.CustomerModels]', but this dictionary requires a model item of type 'CustomerBook.Models.CustomerModels'. plz tell me where m i wrong
MVC in asp.net view not coming
- Thread starter Ames
- Start date