求救:实现多个表的联合绑定在datagrid

Question

select subject.subjectID,subject.subTitle,subject.Profession,subject.MaxNumber,subject.addtime from choosesub,subject where choosesub.userID='"+id+"' and subject.subjectID=choosesub.subjectID
这样写不正确select a.subjectID,a.subTitle,a.Profession,a.MaxNumber,a.addtime from choosesub b,subject a where b.userID='"+id+"' and a.subjectID=b.subjectID

Answer 1

把 choosesub和 subject表分别定义成b,a.

Answer 2

这样写后,那么在datagrid中的
<asp:HyperLinkColumn Target="_blank" DataNavigateUrlField="showcontentdetails.aspx?id={0}" DataTextField="subject.subTitle"HeaderText="课题题目" NavigateUrl="subject.subjectID"></asp:HyperLinkColumn>
的subject.subjectID怎么改

Answer 3

<asp:HyperLinkColumn Target="_blank" DataNavigateUrlField="showcontentdetails.aspx?id={0}" DataTextField="subject.subTitle" HeaderText="课题题目" NavigateUrl="subject.subjectID"></asp:HyperLinkColumn>
=======================================================================
<asp:HyperLinkColumn Target="_blank" DataNavigateUrlField="showcontentdetails.aspx?id={0}" DataTextField="subTitle" HeaderText="课题题目" NavigateUrl="subjectID"></asp:HyperLinkColumn>

Answer 4

这样写后提示错误:选定数据源上未能找到名称为“showcontentdetails.aspx?id={0}”的字段或属性。 

Answer 5

<asp:HyperLinkColumn Target="_blank" DataNavigateUrlField="showcontentdetails.aspx?id={0}" DataTextField="subject.subTitle"HeaderText="课题题目" NavigateUrl="subject.subjectID"></asp:HyperLinkColumn>
的subject.subjectID怎么改
___________________________________________________________________
<asp:HyperLinkColumn Target="_blank" DataNavigateUrlField="showcontentdetails.aspx?id={0}" DataTextField="subTitle"HeaderText="课题题目" NavigateUrl="subjectID"></asp:HyperLinkColumn>