controller层获取数据库中某字段的值,然后由view层接收。
controller层代码如下:
public ActionResult Index(string movieGenre,string searchString)
{
var GenreLst = new List<string>();
var GenreQry = from d in db.Movies
orderby d.Genre
select d.Genre;
GenreLst.AddRange(GenreQry.Distinct());
//GenreLst.Add("test");
//GenreLst.Add("ss");
ViewBag.movieGenre = new SelectList(GenreLst);
var movies = from m in db.Movies
select m;
if (!String.IsNullOrEmpty(searchString))
{
movies = movies.Where(s => s.Title.Contains(searchString));
}
if (!string.IsNullOrEmpty(movieGenre))
{
movies = movies.Where(x => x.Genre == movieGenre);
}
return View(movies);
}
view层代码如下;
<p>
@Html.ActionLink("Create New", "Create")
@using (Html.BeginForm("Index","Movies",FormMethod.Get)){
<p>
Genre:@Html.DropDownList("movieGenre","All")
Title:@Html.TextBox("SearchString")
<input type="submit" value="搜索" />
</p>
}
</p>