Reapter绑定两个表的数据

 太原市 物业公司 | 大同市 搬家公司

完整代码如下：

      <asp:Repeater ID="Repeater4" runat="server">
               <ItemTemplate>
                      <a href="12591141<%=CityID%>0<%#SecondTypeID%>00.html" target="_self">
                       <%#CityName.Replace("市", "") + Eval("SecondTypeName").ToString()%> | </a>
                </ItemTemplate>
      </asp:Repeater>

后台代码如下：   

private void CityNameSecondTypeNameBind()
    {

//取出市名称
        string sql1 = "select * from View_ProvinceCity where CityID=" + CityID + "";
        DataSet dsCity = db.getDs(sql1, "View_ProvinceCity");
        CityName = dsCity.Tables[0].Rows[0]["CityName"].ToString();

        string sql2 = "select * from ChannelSecondType_View where SecondTypeID="+SecondTypeID+"";
        DataSet dsSecondType1 = db.getDs(sql2, "ChannelSecondType_View");
        string ChannelId = dsSecondType1.Tables[0].Rows[0]["ChannelId"].ToString();

//绑定reapter数据

        string sql3 = "select * from ChannelSecondType_View where ChannelId=" + ChannelId + "";
        DataSet dsSecondType2 = db.getDs(sql3, "ChannelSecondType_View");
        this.Repeater4.DataSource = dsSecondType2;
        this.Repeater4.DataBind();
    }