双11狂欢大促

盲盒赢 定制羽绒服

开启惊喜盲盒，抽取你的专属好礼

— 惊喜奖品抢先看 —

超级年卡50元券

周边70元券

手机支架

一拖三数据线

雨伞

运动毛巾

电动牙刷

VIP月卡

机械键盘

定制羽绒服

超级年卡50元券

周边70元券

手机支架

一拖三数据线

雨伞

运动毛巾

电动牙刷

VIP月卡

机械键盘

定制羽绒服

请问父子表的横向显示该如何实现

2012-10-08 04:41:55 178 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

honeyrose 墨衍会员 · AI 创作全网分发关注 + 加入社区

STRING数据库的蛋白质相互作用（PPI）网络分析在转录调控相关的文献中，我们经常能够看到这样的蛋白质相互作用网络（protein protein interaction network，PPI network）。具体而言，这些相关的文献中首先通过RNA-seq、表达谱芯片或者蛋白质组分析等，找到了在不同分组样本间一系列的差异表达基因或蛋白。阅读详情

表结构
父亲 NUMBER(2),
子 NUMBER(2)

显示成这样
父亲1
子1 子2、子3
父亲2
子1、子2

附：create table OPCKB_WK_CATEGORY
(
CATEGORYNAME VARCHAR2(50),
DISPLAYORDER NUMBER(2),
DOCS NUMBER(5),
IMAGE VARCHAR2(255),
NAVIGATION VARCHAR2(255),
DP VARCHAR2(255),
PID NUMBER(2),
CATEGORYID NUMBER(2)
)
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('开发方案', null, null, null, null, null, 1, 5);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('成果类型及共享方式', null, null, null, null, null, 1, 27);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('实用工具', null, null, null, null, null, 1, 26);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('油气层保护', null, null, null, null, null, 2, 28);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('机械采油', null, null, null, null, null, 2, 29);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('水平井采油', null, null, null, null, null, 2, 30);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('三次采油', null, null, null, null, null, 2, 31);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('分层注水', null, null, null, null, null, 2, 32);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('套损井修复', null, null, null, null, null, 2, 33);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('油气集输', null, null, null, null, null, 3, 34);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('油田三水', null, null, null, null, null, 3, 35);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('供配电', null, null, null, null, null, 3, 36);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('道路建设', null, null, null, null, null, 3, 37);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('给排水', null, null, null, null, null, 3, 38);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('自控仪表', null, null, null, null, null, 3, 39);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('防腐检测', null, null, null, null, null, 3, 40);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('事故预案', null, null, null, null, null, 3, 41);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('油田场站', null, null, null, null, null, 3, 42);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('油藏工程', null, null, null, null, null, 0, 1);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('采油工程', null, null, null, null, null, 0, 2);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('地面工程', null, null, null, null, null, 0, 3);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('信息产业', null, null, null, null, null, 0, 4);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('储层描述', null, null, null, null, null, 1, 6);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('动态分析', null, null, null, null, null, 1, 7);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('数据管理', null, null, null, null, null, 4, 8);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('网络管理', null, null, null, null, null, 4, 9);
insert into OPCKB_WK_CATEGORY (CATEGORYNAME, DISPLAYORDER, DOCS, IMAGE, NAVIGATION, DP, PID, CATEGORYID)
values ('软件开发', null, null, null, null, null, 4, 10);
commit;

...全文

便携式水下动态实时视频色彩还原设备，一键快速实现对水下偏色视频和图像的色彩还原处理便携式水下动态实时视频色彩还原，一键快速对水下图像进行色彩校正，清晰度提升和亮度均衡处理，为水下资源勘探和科学考古，海洋生态环境监测，水下机器作业等应用提供有力的协助阅读详情

honeyrose

C# 111,129 成员 642,540 内容

+ 关注 + 加入社区

切换为时间正序

honeyrose 2012-10-09

打赏
举报

可以了，名字弄重了

honeyrose 2012-10-09

打赏
举报

非常感谢
protected void rpt_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
DataRowView drv = (DataRowView)e.Item.DataItem;
Repeater repeater = (Repeater)e.Item.FindControl("rpt2");
string strSQL="select CATEGORYID from 你的表名 where PID="+drv["PID"].ToString();
DataSet ds = XXX(strSQL);
repeater.DataSource = ds; repeater.DataBind();
}
}
可是错误 54 “opckb_net.test.Repeater”不包含“DataSource”的定义，并且找不到可接受类型为“opckb_net.test.Repeater”的第一个参数的扩展方法“DataSource”(是否缺少 using 指令或程序集引用?) G:\My Documents\Visual Studio 2008\Projects\opckb_net\opckb_net\test\Repeater.aspx.cs 42 26 opckb_net

暖枫无敌 2012-10-08

打赏
举报

用Repeater嵌套实现很方便,下面手动给你敲了主要的代码，大致思路就是这样的





<asp:Repeater ID="rpt" runat="server" onitemdatabound="rpt_ItemDataBound">

        <HeaderTemplate>

                    <table>

        </HeaderTemplate>

        <ItemTemplate>

                       <tr>

                               <td><%#Eval("PID")%></td>

                       </tr>

                       <tr>

                                <td>

                                         <asp:Repeater ID="rpt2" runat="server">

                                                    <ItemTemplate>

                                                              <%#Eval("CATEGORYID")%>

                                                    </ItemTemplate>

                                         </asp:Repeater>

                                </td>

                      </tr>

       </ItemTemplate>

       <FooterTemplate>

                  </table>

      </FooterTemplate>

</asp:Repeater>



public void Page_Load(object sender,EventArgs e)

{

      if(!IsPostBack)

      {

             string strSQL = "select distinct(PID) as PID from 你的表名"; //绑定上面一层的父ID

             this.rpt.DataSource = XXX(strSQL);

             this.rpt.DataBind();

      }

}



protected void rpt_ItemDataBound(object sender, RepeaterItemEventArgs e)

{

        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)

        {

             DataRowView drv = (DataRowView)e.Item.DataItem;

             Repeater repeater = (Repeater)e.Item.FindControl("rpt2");

             string strSQL="select CATEGORYID from 你的表名 where PID="+drv["PID"].ToString();

             DataSet ds = XXX(strSQL);

             repeater.DataSource = ds;

             repeater.DataBind();

         }

}

honeyrose 2012-10-08

打赏
举报

select t.CATEGORYID,t.pid
from OPCKB_WK_CATEGORY t
start with t.pid=0
connect by prior CATEGORYID= pid; 这样只能查一级出来，关键是不知道怎么在这个结果的基础上显示下一层。
油藏工程
储层描述动态分析。。
采油工程
水平井采油机械采油。。

✦双11狂欢大促✦

请问父子表的横向显示该如何实现

相关推荐

双11狂欢大促