復(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上即可。