后台用的access数据库,这个dataset的sql语句是这样的:Select * from Line left outer join Company on Line.CompanyID=Company.CompanyID前台DataGrid用<asp:HyperLinkColumn DataNavigateUrlField="Company.CompanyID">可以得到数据,但是如果我用<asp:TemplateColumn>
<ItemTemplate>
<%#DataBinder.Eval(Container.DataItem,"Company.CompanyID")%>
</ItemTemplate>它就说Company.CompanyID不是有效的数据项,我用CompanyID还是无效,请问这里如果想在TemplateColumn中得到这个Company.CompanyID,该怎么办啊?
谢谢!!
<ItemTemplate>
<%#DataBinder.Eval(Container.DataItem,"Company.CompanyID")%>
</ItemTemplate>它就说Company.CompanyID不是有效的数据项,我用CompanyID还是无效,请问这里如果想在TemplateColumn中得到这个Company.CompanyID,该怎么办啊?
谢谢!!
Select *,company.companyid from Line left outer join Company on Line.CompanyID=Company.CompanyID
<asp:Label ID="lab" runat=server Text=Text='<%#DataBinder.Eval(Container.DataItem,"Company.CompanyID") %>'></asp:Label>
</ItemTemplate>
<ItemTemplate>
<asp:Label ID="lab" runat=server Text='<%#DataBinder.Eval(Container.DataItem,"Company.CompanyID") %>'></asp:Label>
</ItemTemplate>
<ItemTemplate>
<%#DataBinder.Eval(Container.DataItem,"CompanyID")%>
</ItemTemplate>
Select a.*,b.companyid as bcompanyid from Line a left outer join Company b on a.CompanyID=b.CompanyID
<ItemTemplate>
<%#DataBinder.Eval(Container.DataItem,"bcompanyid")%>