绑定一张表可以:
IQueryable<News> BindData()
{
IQueryable<News> q = dalPersonnel.News;
return q;
}
void bind()
{
Repeater1.DataSource = BindData();
Repeater1.DataBind();
}
但是两张表怎么办?
IQueryable<News,NewsToWho> BindData()
{
IQueryable<News,NewsToWho> q = from w in dalPersonnel.NewsToWho
from n in dalPersonnel.News
where w.NewsId == n.NewsId
select new {w.Readed,n.NewsId, n.Title, n.NTime};
return q;
}
会出错:
无法将类型“System.Linq.IQueryable<AnonymousType#1>”隐式转换为“System.Linq.IQueryable<object>”。存在一个显式转换(是否缺少强制转换?)该怎么做呢?
IQueryable<News> BindData()
{
IQueryable<News> q = dalPersonnel.News;
return q;
}
void bind()
{
Repeater1.DataSource = BindData();
Repeater1.DataBind();
}
但是两张表怎么办?
IQueryable<News,NewsToWho> BindData()
{
IQueryable<News,NewsToWho> q = from w in dalPersonnel.NewsToWho
from n in dalPersonnel.News
where w.NewsId == n.NewsId
select new {w.Readed,n.NewsId, n.Title, n.NTime};
return q;
}
会出错:
无法将类型“System.Linq.IQueryable<AnonymousType#1>”隐式转换为“System.Linq.IQueryable<object>”。存在一个显式转换(是否缺少强制转换?)该怎么做呢?
IQueryable<***>
***可以用视图或存储过程,在其中设两张表JOIN。