我的数据库选择语句select * from News_Article left join News_Class on News_Article.ClassID=News_Class.ClassID;
在前台用repeter时,我想读取字段"ClassID",也就是<%# Eval("ClassID")%>,但这是作为关联的字段读不出来,有什么办法能把它读出来吗?
在前台用repeter时,我想读取字段"ClassID",也就是<%# Eval("ClassID")%>,但这是作为关联的字段读不出来,有什么办法能把它读出来吗?
<%# Eval("ArtcID")%>
select News_Article .*,News_Class.*,News_Article.ClassID as ArtcID from News_Article left join News_Class on News_Article.ClassID=News_Class.ClassID 倒是没试过这种情况,Repeart有2列名相同会Eval不出来
select News_Article.ClassID
from News_Article left join News_Class
on News_Article.ClassID=News_Class.ClassID试着只取ClassID看看吧
AccessDataSource1.SelectCommand = "select * from News_Article left join News_Class on News_Article.ClassID=News_Class.ClassID";
AccessDataSource1.DataFile = "~/App_Data/AccessData.mdb";