要将同一部门和部门内的员工全显示出来 怎么做啊？

Question

现在在同一个页面里。要将同一部门和部门内的员工全显示出来 
而且可以选择保存其对应的权限，，，请问这该怎么做啊？ 
看图 

Answer 1

嵌套datalist后台代码://TwoFun和ThreeFun是两个表,ThreeFun是TwoFun的子表
System.Data.SqlClient.SqlConnection conn=new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
    System.Data.SqlClient. SqlDataAdapter cmd1 = new System.Data.SqlClient.SqlDataAdapter("Select * from TwoFun where OneFunSID=1",conn);
    DataSet Ds=new DataSet();
    cmd1.Fill(Ds,"TwoFun");    System.Data.SqlClient. SqlDataAdapter cmd2 = new System.Data.SqlClient.SqlDataAdapter("Select * from ThreeFun",conn);
    cmd2.Fill(Ds,"ThreeFun");
    Ds.EnforceConstraints=false;
    Ds.Relations.Add("Two_Three1",Ds1.Tables["TwoFun"].Columns["TwoFunSID"],Ds.Tables["ThreeFun"].Columns["TwoFunSID"]);
    DataList8.DataSource=Ds.Tables["TwoFun"].DefaultView;
    DataList8.DataBind();前台数据绑定的代码:
 <asp:datalist id="DataList8" runat="server" ShowHeader="False" RepeatDirection="Horizontal" ShowFooter="False"
                       RepeatColumns="1" Width="456px">
                       <ItemStyle Font-Size="X-Small"></ItemStyle>
                       <ItemTemplate>
                        <TABLE id="Table4" cellSpacing="0" cellPadding="0" width="98%" border="0">
                         <TR>
                          <TD><IMG height="9" src="images/dian_4.jpg" width="6"><A href="#" target="_top"><FONT style="FONT-WEIGHT: normal; FONT-SIZE: 12px; FONT-FAMILY: 宋体"><%#DataBinder.Eval(Container.DataItem,"TwoFunName")%></FONT></A></TD>
                         </TR>
                         <TR>
                          <TD>
                           <asp:DataList id=DataList9 runat="server" ShowHeader="False" RepeatDirection="Horizontal" ShowFooter="False" RepeatColumns="6" Width="98%" DataSource='<%# ((System.Data.DataRowView)Container.DataItem).CreateChildView("Two_Three1") %>' RepeatLayout="Flow">
                            <ItemStyle Font-Size="X-Small"></ItemStyle>
                            <ItemTemplate>
                             &nbsp;&nbsp;<A href="#" target="_top"><FONT style="FONT-WEIGHT: normal; FONT-SIZE: 12px; FONT-FAMILY: 宋体">
                               <%#DataBinder.Eval(Container.DataItem,"ThreeFunName")%>
                              </FONT></A>
                            </ItemTemplate>
                           </asp:DataList></TD>
                         </TR>
                        </TABLE>
                       </ItemTemplate>
                      </asp:datalist>//子DataList中的DataSouse的指定,前台代码中黄色背景部分

Answer 2

用了你说的可改成我的数据库时，        if (!IsPostBack)
        {
 
            //TrainPerson = TrainPerson + "";
            System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conStr"]);
            System.Data.SqlClient.SqlDataAdapter cmd1 = new System.Data.SqlClient.SqlDataAdapter("Select * from RS_D_INTOMATION ", conn);
            DataSet Ds = new DataSet();
            cmd1.Fill(Ds, "RS_D_INTOMATION");////这里说对象名 'RS_D_INTOMATION' 无效。
            System.Data.SqlClient.SqlDataAdapter cmd2 = new System.Data.SqlClient.SqlDataAdapter("Select * from RS_PERSON", conn);
            cmd2.Fill(Ds, "RS_PERSON");
            Ds.EnforceConstraints = false;
            Ds.Relations.Add("Two_Three1", Ds.Tables["RS_D_INTOMATION"].Columns["INFO_ID"], Ds.Tables["RS_PERSON"].Columns["P_DEPARTMENT"]);
            DataList8.DataSource = Ds.Tables["RS_D_INTOMATION"].DefaultView;
            DataList8.DataBind();