<%@ Page Language="C#" Inherits="System.Web.Mvc.ViewPage<Mvc1.Models.BaseList>" %> <%@Import Namespace="Mvc1.Models" %> 对应 @model MvcApp3.Models.recordsets @using MvcApp3.Models 注意,此时后面是 @foreach(minzhu item in Model.minzhus){<td class="style2">@item.检索码 </td>} 如果采取 IEnumerable 元素的模式 : @model IEnumerable<MvcApp3.Models.recordsets>则后面变成了 @foreach(var item in Model){<td class="style2">@item.检索码 </td>} ████████████████████████████████████████████████████████████████████████ <% foreach (ProductInfo prod in Model.Prods) { %> 对应 @foreach (ProductInfo prod in Model.Prods) { } ████████████████████████████████████████████████████████████████████████ 注意,定义的表类需要单独放在一个类中, 定义的数据集(基于表类)的,需要单独放在一个类中, 但是,如果是此类的方法,可以放置在此数据集类中,如下: public class recordsets { public IList<minzhu> minzhus { get; set; } //定义实体类 public IList<minzhu> GetAll() { IList<minzhu> dals = new List<minzhu>(); //实例化 string ConnStr = ConfigurationManager.ConnectionStrings["conns"].ConnectionString; using (SqlConnection conn = new SqlConnection(ConnStr)) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "select 编号,类别,名称,代码,检索码 from ct_bianma where 类别='文化程度'"; try { conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { minzhu dal = new minzhu() //指一行记录 下同 dal.编号= { 编号 = dr.GetInt32(0), 代码 = dr.GetString(1), 检索码 = dr.GetString(2), 类别 = dr.GetString(3), 名称 = dr.GetString(4), }; dals.Add(dal); } } catch (SqlException e) { throw e; } } return dals; } } ████████████████████████████████████████████████████████████████████████
public ViewResult index2() { string ConnStr = ConfigurationManager.ConnectionStrings["conns"].ConnectionString; var list = new List<string>(); list.Clear(); using (SqlConnection conn = new SqlConnection(ConnStr)) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "select distinct 名称 from ct_bianma where 类别='文化程度'"; try { conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); //this.lbxCodeDepartment.Items. // Add(string.Format("{0}\t{1}", "编码", "院系名称")); while (dr.Read()) { // list.Add(string.Format("{0}", dr.GetValue(0))); list.Add(dr.GetValue(0).ToString()); } } catch (SqlException sex) { throw sex; } } ViewBag.list02 = new SelectList(list); return View("index2"); // 8 种 }