相对于上一次的使用Relation的缺点:
1. 不能限制返回的纪录数;2. 邦定时不方便,甚至不能邦定上;3. 程序简单,但不容易理解。4. 可能对于三层以上的嵌套不容易实现。
这次给出的嵌套方案,使用的ItemDataBound事件进行嵌套,实现起来很方便,其容易理解。并且解决了以上四个问题。
以下是主要的代码:
<asp:DataList ID="DList_Class" DataKeyField="NavigatorID"
BackColor="#ffffff" BorderWidth="0px" CellPadding="1"
ShowFooter="False" ShowHeader="False" runat="server"
CellSpacing="20" HorizontalAlign="Justify" RepeatColumns="2"
RepeatDirection="Horizontal" RepeatLayout="Table" >
<itemstyle VerticalAlign=Top></itemstyle>
<itemtemplate>
<b><%# DataBinder.Eval(Container.DataItem,"NavigatorID") %> @
<%# DataBinder.Eval(Container.DataItem,"NodeCaption") %></b>
<hr>
<asp:DataGrid ID=DG_SubClass Width=315px Runat=server
AutoGenerateColumns="false"
ShowHeader="false" ShowFooter="false" PageSize="10" AllowPaging="true"
PagerStyle-Visible="false" BorderWidth="1" BackColor="#ffffff" BorderColor="#ffffff"
CellPadding="0" CellSpacing="0" GridLines=Horizontal
OnItemDataBound='DG_SubClass_ItemDataBound'>
<ItemStyle Height="14px" BackColor="#e3f1ff" CssClass="gridHover"></ItemStyle>
<Columns>
<asp:BoundColumn DataField ="ModuleType" ReadOnly=True >
<ItemStyle Width=25 HorizontalAlign=Center ></ItemStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="NodeCaption" >
<ItemStyle HorizontalAlign=Left CssClass="nav"></ItemStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField ="ModuleType" ReadOnly=True>
<ItemStyle Width=90 HorizontalAlign=Center></ItemStyle>
</asp:BoundColumn>
</Columns>
</asp:DataGrid>
</itemtemplate>
</asp:DataList>
private void DList_Class_ItemDataBound(object sender, System.Web.UI.WebControls.DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
DataGrid dg=(DataGrid)e.Item.FindControl("DG_SubClass");
string itemIndex =this.DList_Class.DataKeys[e.Item.ItemIndex].ToString();
string[] strSqlArray =new string[3]{"select Top 10 IOrder, ILevel, IParentID, NavigatorID, NodeCaption,ModuleID, ModuleType from NavigatorNodes where IParentID in ( ", itemIndex, ");"};
string strSql=string.Concat(strSqlArray);
string TableName ="SubClass"+itemIndex;
this.dbClass.AdapterF