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

string con=ConfigurationSettings.AppSettings["con"];
SqlConnection conn=new SqlConnection(con);
conn.Open();
SqlDataAdapter sda=new SqlDataAdapter();
sda.SelectCommand=new SqlCommand("select subject.subjectID,subject.subTitle,subject.Profession,subject.MaxNumber,subject.addtime from choosesub,subject where choosesub.userID='"+id+"' and subject.subjectID=choosesub.subjectID",conn);

DataSet ds=new DataSet();
sda.Fill(ds,"choose");
this.dgchoosed.DataKeyField="subjectID";
this.dgchoosed.DataSource=ds;
this.dgchoosed.DataBind();


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

--------------------编程问答-------------------- 如樓上
<asp:HyperLinkColumn Target="_blank" DataNavigateUrlField="showcontentdetails.aspx?id={0}" DataTextField="subTitle" HeaderText="课题题目" NavigateUrl="subjectID"></asp:HyperLinkColumn>

你用查詢器執行一下看查出來的結果顯示的字段就只有subjectID不會是subject.subjectID --------------------编程问答-------------------- 更改后出现提示错误:选定数据源上未能找到名称为“showcontentdetails.aspx?id={0}”的字段或属性。 
--------------------编程问答-------------------- 帮你顶
http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032328189&Culture=zh-CN
datagrid的简单例子

补充：.NET技术 ,  ASP.NET