復(fù)制代碼 代碼如下:
PEAEWebSiteDataContext context = new PEAEWebSiteDataContext();
var p = from n in context.tb_News
where n.cname == "校園信息"
select n;
var pp = p.OrderByDescending(tb_News=>tb_News.issuedate).Take(1);var p1 = from n in context.tb_News
where n.cname == "活動(dòng)安排"
select n;
var pp1 = p1.OrderByDescending(tb_News=>tb_News.issuedate).Take(1);
DataList1.DataSource = pp;
DataList2.DataSource = pp1;
DataList1.DataBind();
DataList2.DataBind();
數(shù)據(jù)源為dbml,通常使用LinqDataSource的話,綁定的數(shù)據(jù)行數(shù)無法限制。
取而代之,在后臺(tái)通過Linq to Sql 自定義的選取數(shù)據(jù),再綁定在Datalist上即可。