62,243
社区成员




[HttpPost]
public ActionResult VideoList(string CName)
{
string cx = "select * from VedioList where Classify = '" + CName + "'" ;
con.Open();
//查询数据并存入集合里
SqlCommand com = new SqlCommand(cx, con);
SqlDataReader sdr = com.ExecuteReader();
while (sdr.Read())
{
video.Add(new Models.VideoList()
{
ID = int.Parse(sdr["ID"].ToString()),
Title = sdr["Title"].ToString(),
MinImg = sdr["MinImg"].ToString(),
VedioUrl = sdr["VedioUrl"].ToString(),
Classify = sdr["Classify"].ToString(),
IsCarousel = Convert.ToBoolean(sdr["IsCarousel"])
});
}
sdr.Close();
com.Dispose();
con.Close();
ViewBag.list = video;
return View();
}