用Linq如何查询2张表的数据显示在一个Repeater里面
table1 有字段 id,title,images
table2 有字段 id,title,images
用Linq如何把两个没有关联的表数据查出来放到Repeater里面呢?
请教各位.
[解决办法]
var query = from p in db.table1 where !db.table2.Any(q=> q.id== p.id) select p;this.Repeater1.DataSource = query;this.Repeater1.DataBind();
[解决办法]
var rs =from order in db.table1.Include("table2")
where(条件)
select order;
Repeater.DataSource = rs;
Repeater.DataBind();
[解决办法]
linq to sql?
var query=db.Table1.Contact(db.Table2).ToList();
this.Repeater1.DataSource = query;
this.Repeater1.DataBind();
[解决办法]
var news = bn.SelectRecordAll();//拿到table1数据
var promo = bp.SelectRecordAll();//拿到table2数据
Repeater1.DataSource = news.Union(promo).ToList();
Repeater1.DataBind();
[解决办法]