DS两个表结合

ds=MyDesign.EduDesignItems("1");
    ds.Tables[0].TableName="itemparent";
     
    ds.Tables[1].TableName="itemchild";
    // MyDesign.EduDesignList(Session["UserName"].ToString());
    ds.Relations.Add("Children",ds.Tables["itemparent"].Columns["SubjectName"],ds.Tables["itemchild"].Columns["SubjectName"]);
    Repeater1.DataSource=ds.Tables["itemparent"].DefaultView;
    Repeater1.DataBind();

    this.Repeater1.DataSource = ds.Tables["itemparent"].DefaultView;
    this.Repeater1.DataBind();

 

 <script language="javascript">
<!--
 function disp_something(str,dd){
 objs=document.all(dd);
 obj=document.all(str);
 if(obj){
  if(obj.style.display==""){
   obj.style.display="none";
   objs.src="../images/open.gif";
  }else if(obj.style.display=="none"){
   obj.style.display="";
   objs.src="../images/close.gif";
  }
 }
}
function DoDel( TypeIndex)
{
  if(confirm('您确定要删除此条记录吗?'))
  {
  window.location.href="TypeIndex.aspx?act=Del&TypeIndex="+TypeIndex+""
  }
}
//-->
  </script>

 


<asp:Repeater id="Repeater1" runat="server">
        <HeaderTemplate>
         <table border="0" width="100%" cellpadding="0" cellspacing="0">
          <tr>
           <th class="Ths" width="120">
            污染指数</th>
           <th class="Ths" width="120">
            标准级别浓度</th>
           <th class="Ths" width="120">
            顺序</th>
           <th class="Ths" width="70">
            修改</th>
           <th class="Ths" width="70">
            删除</th></tr>
        </HeaderTemplate>
        <ItemTemplate>
         <tr height="28">
          <td bgcolor="#F0F0F0" colspan="5">
           &nbsp; <a href="#" οnclick='disp_something("<%#DataBinder.Eval(Container.DataItem,"E_TypeCharCode")%>","<%#DataBinder.Eval(Container.DataItem,"E_TypeID")%>")'>
            <img src="../images/open.gif" border="0" name='<%#DataBinder.Eval(Container.DataItem,"E_TypeID")%>'></a>&nbsp;<b>
            <%#DataBinder.Eval(Container.DataItem,"E_TypeName")%>
            (<%#DataBinder.Eval(Container.DataItem,"E_TypeCharCode")%>) </b>
          </td>
         </tr>
         <tr>
          <td colspan="5"><div id='<%#DataBinder.Eval(Container.DataItem,"E_TypeCharCode")%>' style="display:none">
            <asp:repeater id="Repeater3" runat="server" EnableViewState="False" DataSource='<%#DataBinder.Eval(Container.DataItem,"Children")%>'>
             <HeaderTemplate>
              <table class="list">
             </HeaderTemplate>
             <ItemTemplate>
              <tr>
               <td height="25" align="left" width="120">
                &nbsp; &nbsp; &nbsp;
                <%#DataBinder.Eval(Container.DataItem,"E_TypeIndexValue")%>
               </td>
               <td align="left" width="120">
                <%#DataBinder.Eval(Container.DataItem,"E_TypeIndex_Deep")%>
               </td>
               <td align="left" width="120">
                <%#DataBinder.Eval(Container.DataItem,"E_TypeOrderBy")%>
               </td>
               <td align="left" width="70">
                <a href='EditTypeIndex.aspx?TypeIndex=<%#DataBinder.Eval(Container.DataItem,"E_TypeIndex")%>  '>
                 <img src="../images/update.gif" border="0"></a>
               </td>
               <td align="left" width="70">
                <a href='#' οnclick='DoDel("<%#DataBinder.Eval(Container.DataItem,"E_TypeIndex")%>")'>
                 <img src="../images/del.gif" border="0"></a>
               </td>
              </tr>
             </ItemTemplate>
             <FooterTemplate>
   </table>
   </FooterTemplate> </asp:repeater> </div></td></tr> </ItemTemplate>
   <FooterTemplate>
     </table>
    </FooterTemplate>
   </asp:Repeater>

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值