一个简单的MVC实例及故障排除

Controller:

 1 public ActionResult Index() 2     { 3       get='_blank'>string setting = "ApplicationServices"; 4       var connString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings[setting]; 5       SqlConnection conn = new SqlConnection(connString.ConnectionString); 6       SqlCommand cmd; 7       SqlDataReader datar; 8       string str_sql = "select * from T_category;"; 9       conn.Open();10       cmd = new SqlCommand(str_sql, conn);11       datar = cmd.ExecuteReader();12       List<string> list_categoery = new List<string>();13       while (datar.Read())14       {15         list_categoery.Add(datar["category_name"].ToString());16       }17       conn.Close();18       ViewBag.Categories = list_categoery;19 20       str_sql = "select * from T_product;";21       conn.Open();22       cmd = new SqlCommand(str_sql, conn);23       datar = cmd.ExecuteReader();24       productModel pm = new productModel();25       while (datar.Read())26       {27         pm.product_name = datar["Product_name"].ToString();28         pm.product_description = datar["Product_description"].ToString();29         pm.product_image = datar["Product_image"].ToString();30         pm.product_document = datar["Product_document"].ToString();31       }32       conn.Close();33       return View(pm);34     }

原标题：一个简单的MVC实例及故障排除

关键词：mvc