<%@ 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 种
}