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