datalist中读取另一个表的字段

Question

datalist绑定的是信息表，有一个字段是信息类型存储的是信息类型的ID，我想在显示的时候，根据信息类型ID到信息表中查询显示 出来信息类型的名称。应该怎么做？

Answer 1

这些表关系 在 SQL中处理。

Answer 2

select id,(select 字段 from 表2 where 表1.id=表2.id) as 别名 from 表1

Answer 3

 <asp:DataList ID="datalist1" runat="server">
    <ItemTemplate>
    <asp:Label ID="label1" runat="server" Visible="false" Text='<%#Eval("ID")%>'></asp:Label>
    </ItemTemplate>
    </asp:DataList>后台：根据你的ID去查询 然后绑定

Answer 4

 前台这样绑定：<asp:DataList ID="DataList1" runat="server" Width="98%" >
                                <ItemTemplate >
                               <tr>
                             <td width="3%" align="center" class="fagui"><img src="../../images/index33.jpg" width="6" height="9" /></td>
                            <td width="55%" align="left" class="fagui"><%# GetTxtLink("MessageDetail.aspx?ID=" +(int)Eval("mesID"),Eval("mesTitle").ToString(),20)%></td>
                            <td width="20%" align="left" class="fagui"><asp:Label ID="label1" runat="server" Visible="false" Text='<%#Eval("ID")%>'></asp:Label>                            
     </td>
                            <td width="10%" align="left" class="date"><%# DataBinder.Eval(Container.DataItem,"sendTime","{0:D}") %></td>
                    
                              
                                </tr>
                                </ItemTemplate>
                                <FooterTemplate></FooterTemplate>
                                </asp:DataList>后台： private void showMessage()
    {
        int ID = int.Parse(Request.Cookies["UserInfo"]["userID"].ToString());
        OperateClass CData = new OperateClass();
        //对PagedDataSource 对象的相关属性赋值 
        PagedDataSource objPds = new PagedDataSource();
        objPds.DataSource = CData.ExecuteSqlRead("select * from Message where senderID=" +ID+ "order by mesID desc").DefaultView;
        objPds.AllowPaging = true;
        objPds.PageSize = 22;        FirstPageBt.NavigateUrl = Request.CurrentExecutionFilePath + "&Page=1";        LastPageBt.NavigateUrl = Request.CurrentExecutionFilePath + "&Page=" + objPds.PageCount.ToString();
        lblTotalPage.Text = objPds.PageCount.ToString();
        int CurPage;        //当前页面从Page查询参数获取 
        if (Request.QueryString["Page"] != null)
            CurPage = Convert.ToInt32(Request.QueryString["Page"]);
        else
            CurPage = 1;        objPds.CurrentPageIndex = CurPage - 1;
        lblCurrentPage.Text = CurPage.ToString();
        if (!objPds.IsFirstPage)
            lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "&Page=" + Convert.ToString(CurPage - 1);        if (!objPds.IsLastPage)
            lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "&Page=" + Convert.ToString(CurPage + 1);        this.DataList1.DataSource = objPds;        this.DataList1.DataBind();
    }在这里应该怎么修改？上边的代码只能查出类型ID，Label1的值怎么显示出来啊？