This is a migrated thread and some comments may be shown as answers.

hierarchy table in 4 layer not showing

2 Answers 35 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Smit asked on 12 Jan 2014, 10:15 PM

Untitled.png

I have problem to hierarchy table in 4 layer not showing
--
   table1
             table2
                       table3
                                 table4(not showing)

 

 <%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage_Menu.master" AutoEventWireup="true" CodeFile="Coding.aspx.cs" Inherits="Coding" %> 

  

 <asp:Content ID="Content1" ContentPlaceHolderID="nestedContent" Runat="Server"> 

  

  

 <form id="form1" runat ="server"> 

 <div style="min-height:600px"> 

 <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> 

 <Scripts> 

 <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" /> 

 <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" /> 

 <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" /> 

 </Scripts> 

 </telerik:RadScriptManager> 

 <telerik:RadGrid ID="RadGrid1" ShowStatusBar="True"  

 AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowAutomaticDeletes="True" 

 DataSourceID="SqlDataSource1" runat="server" AutoGenerateColumns="False" PageSize="15" 

 AllowSorting="True" AllowMultiRowSelection="True" AllowPaging="True" 

 OnItemUpdated="RadGrid1_ItemUpdated" OnItemDeleted="RadGrid1_ItemDeleted" 

 OnItemInserted="RadGrid1_ItemInserted" OnInsertCommand="RadGrid1_InsertCommand" 

 Height="95px" onupdatecommand="RadGrid1_UpdateCommand" 

 > 

 <PagerStyle Mode="NumericPages"></PagerStyle> 

 <MasterTableView DataSourceID="SqlDataSource1" Font-Names="Tahoma" DataKeyNames="GroupHesabId" CommandItemDisplay="Top" 

 Name="GroupHesab" AllowMultiColumnSorting="True" ExpandCollapseColumn-Display="true" Dir ="RTL" ItemStyle-BackColor="#00CCFF" AlternatingItemStyle-BackColor="#00CCFF" 

 RowIndicatorColumn-Display="false" AllowAutomaticUpdates="True" EditMode ="PopUp" > 

 <DetailTables> 

 <telerik:GridTableView Caption="جدول گروه حسابها" Name="Kol" DataKeyNames="KolId" EditMode ="InPlace" ItemStyle-BackColor="Yellow" AlternatingItemStyle-BackColor="Yellow" 

 runat="server" CommandItemDisplay="Top" Font-Names="Tahoma" DataSourceID="SqlDataSource2" EditItemStyle-HorizontalAlign="Right"> 

 <ParentTableRelation> 

 <telerik:GridRelationFields DetailKeyField="GroupHesabId" MasterKeyField="GroupHesabId"></telerik:GridRelationFields> 

 </ParentTableRelation> 

 <DetailTables> 

 <telerik:GridTableView Caption="" Name="Moien" DataKeyNames="MoeinId" EditMode ="PopUp" Font-Names="Tahoma" ItemStyle-BackColor="#80E680" AlternatingItemStyle-BackColor="#80E680" 

 runat="server" CommandItemDisplay="Top" DataSourceID="SqlDataSource3" Dir="RTL" EditItemStyle-HorizontalAlign="Right"> 

 <ParentTableRelation> 

 <telerik:GridRelationFields DetailKeyField="KolId" MasterKeyField="KolId"></telerik:GridRelationFields> 

 </ParentTableRelation> 

 <DetailTables> 

 <telerik:GridTableView Name="TafsiliGroupMoien" DataKeyNames="TafsiliGroupMoienId" EditMode ="PopUp" Font-Names="Tahoma" ItemStyle-BackColor="#80E680" AlternatingItemStyle-BackColor="#80E680" 

 runat="server" AutoGenerateColumns="false" CommandItemDisplay="Top" DataSourceID="TafsiliGroupMoienSqlDataSource" Dir="RTL" EditItemStyle-HorizontalAlign="Right"> 

 <ParentTableRelation> 

 <telerik:GridRelationFields DetailKeyField="MoienId" MasterKeyField="MoienId"></telerik:GridRelationFields> 

 </ParentTableRelation> 

  

 <Columns> 

 <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumnTafsiliGroup"> 

 <HeaderStyle Width="20px"></HeaderStyle> 

 </telerik:GridEditCommandColumn> 

  

 <telerik:GridTemplateColumn HeaderText="گروه تفصیلی" ItemStyle-Width="240px"> 

 <ItemTemplate> 

 <%#DataBinder.Eval(Container.DataItem, "TafsiliGroupName")%> 

 </ItemTemplate> 

 <EditItemTemplate> 

 <telerik:RadComboBox runat="server" ID="RadComboBox6" DataTextField="TafsiliGroupName" 

 DataValueField="TafsiliGroupId" DataSourceID="TafsiliGroupDataSource" SelectedValue='<%#Bind("TafsiliGroupId") %>' > 

 </telerik:RadComboBox> 

 </EditItemTemplate> 

  

 <ItemStyle Width="240px"></ItemStyle> 

 </telerik:GridTemplateColumn> 

  

 <telerik:GridButtonColumn ConfirmText="آیا این گروه تفصیلی حذف گردد؟" ButtonType="ImageButton" 

 CommandName="Delete" Text="Delete" UniqueName="DeleteColumn4"> 

 <HeaderStyle Width="20px"></HeaderStyle> 

 <ItemStyle HorizontalAlign="Center" CssClass="MyImageButton"></ItemStyle> 

 </telerik:GridButtonColumn> 

 </Columns> 

 <EditFormSettings> 

 <EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn> 

 </EditFormSettings> 

  

 <ItemStyle BackColor="#80E680"></ItemStyle> 

  

 <AlternatingItemStyle BackColor="#80E680"></AlternatingItemStyle> 

  

 <EditItemStyle HorizontalAlign="Right"></EditItemStyle> 

  

 <PagerStyle PageSizeControlType="RadComboBox"></PagerStyle> 

  

 </telerik:GridTableView> 

 </DetailTables> 

  

 <Columns> 

 <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn"> 

 <HeaderStyle Width="20px"></HeaderStyle> 

 </telerik:GridEditCommandColumn> 

  

 <telerik:GridBoundColumn SortExpression="MoienNum" ItemStyle-HorizontalAlign="Right" HeaderText="کد معین" HeaderButtonType="TextButton" 

 DataField="MoienNum" UniqueName="MoienNum" HeaderStyle-Font-Bold="true" ItemStyle-Width="50"> 

 <HeaderStyle Font-Bold="True"></HeaderStyle> 

  

 <ItemStyle HorizontalAlign="Right" Width="50px"></ItemStyle> 

 </telerik:GridBoundColumn> 

 <telerik:GridBoundColumn SortExpression="MoienName" HeaderStyle-Font-Bold="true" ItemStyle-HorizontalAlign="Right" HeaderText="نام معین" HeaderButtonType="TextButton" 

 DataField="MoienName" UniqueName="MoienName"> 

 <HeaderStyle Font-Bold="True"></HeaderStyle> 

  

 <ItemStyle HorizontalAlign="Right"></ItemStyle> 

 </telerik:GridBoundColumn> 

 <telerik:GridTemplateColumn HeaderText="ماهیت حساب معین" ItemStyle-Width="240px"> 

 <ItemTemplate> 

 <%#DataBinder.Eval(Container.DataItem, "MahiyatMoinName")%> 

 </ItemTemplate> 

 <EditItemTemplate> 

 <telerik:RadComboBox runat="server" ID="RadComboBox2" DataTextField="MahiyatMoinName" 

 DataValueField="MahiyatMoinID" DataSourceID="MahiyatMoienDataSource" SelectedValue='<%#Bind("MahiyatMoinID") %>' > 

 </telerik:RadComboBox> 

 </EditItemTemplate> 

  

 <ItemStyle Width="240px"></ItemStyle> 

 </telerik:GridTemplateColumn> 

  

 <telerik:GridButtonColumn ConfirmText="آیا این حساب معین حذف گردد؟" ButtonType="ImageButton" 

 CommandName="Delete" Text="Delete" UniqueName="DeleteColumn2"> 

 <HeaderStyle Width="20px"></HeaderStyle> 

 <ItemStyle HorizontalAlign="Center" CssClass="MyImageButton"></ItemStyle> 

 </telerik:GridButtonColumn> 

  

 </Columns> 

  

 <EditFormSettings> 

 <EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn> 

 </EditFormSettings> 

  

 <ItemStyle BackColor="#80E680"></ItemStyle> 

  

 <AlternatingItemStyle BackColor="#80E680"></AlternatingItemStyle> 

  

 <EditItemStyle HorizontalAlign="Right"></EditItemStyle> 

  

 <PagerStyle PageSizeControlType="RadComboBox"></PagerStyle> 

 </telerik:GridTableView> 

 </DetailTables> 

  

 <CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings> 

  

 <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn> 

  

 <ExpandCollapseColumn Visible="True" Created="True" FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn> 

 <Columns> 

  

 <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn"> 

 <HeaderStyle Width="20px"></HeaderStyle> 

 <ItemStyle CssClass="MyImageButton"></ItemStyle> 

 </telerik:GridEditCommandColumn> 

  

 <telerik:GridBoundColumn ItemStyle-HorizontalAlign="Right" SortExpression="KolNum" HeaderStyle-Font-Bold="true" HeaderText="کد حساب کل" HeaderButtonType="TextButton" ItemStyle-Width="50" 

 DataField="KolNum" UniqueName="KolNum"> 

 <HeaderStyle Font-Bold="True"></HeaderStyle> 

  

 <ItemStyle HorizontalAlign="Right" Width="50px"></ItemStyle> 

 </telerik:GridBoundColumn> 

 <telerik:GridBoundColumn SortExpression="KolName" HeaderText="نام حساب کل" HeaderStyle-Font-Bold="true" HeaderButtonType="TextButton" 

 DataField="KolName" UniqueName="KolName"> 

  

 <HeaderStyle Font-Bold="True"></HeaderStyle> 

 </telerik:GridBoundColumn> 

 <telerik:GridTemplateColumn HeaderText="ماهیت حساب کل" ItemStyle-Width="240px"> 

 <ItemTemplate> 

 <%#DataBinder.Eval(Container.DataItem, "MahiyatKolName")%> 

 </ItemTemplate> 

 <EditItemTemplate> 

 <telerik:RadComboBox runat="server" ID="RadComboBox2" DataTextField="MahiyatKolName" 

 DataValueField="MahiyatKolId" DataSourceID="MahiyatKolDataSource" SelectedValue='<%#Bind("MahiyatKolId") %>' > 

 </telerik:RadComboBox> 

 </EditItemTemplate> 

  

 <ItemStyle Width="240px"></ItemStyle> 

 </telerik:GridTemplateColumn> 

 <telerik:GridButtonColumn ConfirmText="آیا این حساب کل حذف گردد؟" ButtonType="ImageButton" 

 CommandName="Delete" Text="Delete" UniqueName="DeleteColumn3"> 

 <HeaderStyle Width="20px"></HeaderStyle> 

 <ItemStyle HorizontalAlign="Center" CssClass="MyImageButton"></ItemStyle> 

 </telerik:GridButtonColumn> 

 </Columns> 

  

 <EditFormSettings> 

 <EditColumn UniqueName="EditCommandColumn" FilterControlAltText="Filter EditCommandColumn column"></EditColumn> 

 </EditFormSettings> 

  

 <ItemStyle BackColor="Yellow"></ItemStyle> 

  

 <AlternatingItemStyle BackColor="Yellow"></AlternatingItemStyle> 

  

 <EditItemStyle HorizontalAlign="Right"></EditItemStyle> 

  

 <PagerStyle PageSizeControlType="RadComboBox"></PagerStyle> 

 </telerik:GridTableView> 

 </DetailTables> 

  

 <CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings> 

  

 <RowIndicatorColumn Display="False" FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn> 

  

 <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column" Created="True"></ExpandCollapseColumn> 

 <Columns> 

 <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn"> 

 <HeaderStyle Width="20px"></HeaderStyle> 

 <ItemStyle CssClass="MyImageButton"></ItemStyle> 

 </telerik:GridEditCommandColumn> 

  

 <telerik:GridBoundColumn SortExpression="GroupHsabNum" HeaderText="کد گروه حساب" HeaderStyle-Font-Bold="true" HeaderButtonType="TextButton" ItemStyle-Width="50" 

 DataField="GroupHsabNum" UniqueName="GroupHsabNum"> 

 <HeaderStyle Font-Bold="True"></HeaderStyle> 

  

 <ItemStyle Width="50px"></ItemStyle> 

 </telerik:GridBoundColumn> 

 <telerik:GridBoundColumn SortExpression="GroupHesabName" HeaderText="نام گروه حساب" HeaderStyle-Font-Bold="true" HeaderButtonType="TextButton" 

 DataField="GroupHesabName" UniqueName="GroupHesabName"> 

 <HeaderStyle Font-Bold="True"></HeaderStyle> 

 </telerik:GridBoundColumn> 

  

 <telerik:GridTemplateColumn HeaderText="نوع گروه حساب" ItemStyle-Width="240px"> 

 <ItemTemplate> 

 <%#DataBinder.Eval(Container.DataItem, "TypeOfGroupHesabName")%> 

 </ItemTemplate> 

 <EditItemTemplate> 

 <telerik:RadComboBox runat="server" ID="RadComboBox2" DataTextField="TypeOfGroupHesabName" 

 DataValueField="TypeOfGroupHesabId" DataSourceID="TypeHesabDataSource" SelectedValue='<%#Bind("TypeOfHesabId") %>' > 

 </telerik:RadComboBox> 

 </EditItemTemplate> 

  

 <ItemStyle Width="240px"></ItemStyle> 

 </telerik:GridTemplateColumn> 

  

  

  

 <telerik:GridButtonColumn ConfirmText="آیا این گروه حساب حذف گردد؟" ButtonType="ImageButton" 

 CommandName="Delete" Text="Delete" UniqueName="DeleteColumn4"> 

 <HeaderStyle Width="20px"></HeaderStyle> 

 <ItemStyle HorizontalAlign="Center" CssClass="MyImageButton"></ItemStyle> 

 </telerik:GridButtonColumn> 

 </Columns> 

  

 <EditFormSettings> 

 <EditColumn UniqueName="EditCommandColumn" FilterControlAltText="Filter EditCommandColumn column"></EditColumn> 

 </EditFormSettings> 

  

 <ItemStyle BackColor="#00CCFF"></ItemStyle> 

  

 <AlternatingItemStyle BackColor="#00CCFF"></AlternatingItemStyle> 

  

 <PagerStyle PageSizeControlType="RadComboBox"></PagerStyle> 

  

 </MasterTableView> 

  

 <ClientSettings Selecting-AllowRowSelect="true"> 

 <Selecting AllowRowSelect="True"></Selecting> 

 </ClientSettings> 

  

 <FilterMenu EnableImageSprites="False"></FilterMenu> 

 </telerik:RadGrid> 

 <asp:SqlDataSource ID="TypeHesabDataSource" ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>" 

 ProviderName="System.Data.SqlClient" SelectCommand="SELECT TypeOfGroupHesabId,TypeOfGroupHesabName FROM TypeOfGroupHesab" 

 runat="server"> 

 </asp:SqlDataSource> 

 <asp:SqlDataSource ID="MahiyatKolDataSource" ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>" 

 ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM MahiyatKol" 

 runat="server"> 

 </asp:SqlDataSource> 

 <asp:SqlDataSource ID="MahiyatMoienDataSource" ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>" 

 ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM MahiyatMoien" 

 runat="server"> 

 </asp:SqlDataSource> 

 <asp:SqlDataSource ID="TafsiliGroupDataSource" ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>" 

 ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM TafsiliGroup" 

 runat="server"> 

 </asp:SqlDataSource> 

 <asp:SqlDataSource ID="TafsiliGroupMoienSqlDataSource" ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>" 

 ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM TafsiliGroupMoien tgm inner join TafsiliGroup tg on tgm.TafsiliGroupId=tg.TafsiliGroupId where MoienId=@MoienId" 

 InsertCommand="INSERT INTO TafsiliGroupMoien(MoienId,TafsiliGroupId) VALUES (@MoienId,@TafsiliGroupId)" 

 DeleteCommand="Delete from TafsiliGroupMoien where TafsiliGroupMoienId=@TafsiliGroupMoienId" 

 UpdateCommand ="Update TafsiliGroupMoien Set MoienId=@MoienId ,TafsiliGroupId=@TafsiliGroupId where TafsiliGroupMoienId=@TafsiliGroupMoienId" 

 runat="server"> 

 <UpdateParameters> 

  

 <asp:Parameter Name="MoienId" Type="Int32"></asp:Parameter> 

 <asp:Parameter Name="TafsiliGroupId" Type="Int16"></asp:Parameter> 

 <asp:Parameter Name="TafsiliGroupMoienId" Type="Int32"></asp:Parameter> 

 </UpdateParameters> 

 <DeleteParameters> 

 <asp:Parameter Name="TafsiliGroupMoienId" Type="Int32"></asp:Parameter> 

 </DeleteParameters> 

 <InsertParameters> 

 <asp:Parameter Name="MoienId" Type="Int32"></asp:Parameter> 

 <asp:Parameter Name="TafsiliGroupId" Type="Int16"></asp:Parameter> 

  

 </InsertParameters> 

 <SelectParameters> 

 <asp:SessionParameter Name="MoienId" SessionField="MoienId" Type="string"></asp:SessionParameter> 

 </SelectParameters> 

  

 </asp:SqlDataSource> 

 <asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>" 

 ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM GroupHesab g inner join TypeOfGroupHesab t on t.TypeOfGroupHesabId=g.TypeOfHesabId" 

 InsertCommand="INSERT INTO GroupHesab(GroupHesabName,GroupHsabNum,TypeOfHesabId) VALUES (@GroupHesabName,@GroupHsabNum,@TypeOfHesabId)" 

 DeleteCommand="Delete from GroupHesab where GroupHesabId=@GroupHesabId" 

 UpdateCommand ="Update GroupHesab Set GroupHesabName=@GroupHesabName ,GroupHsabNum=@GroupHsabNum,TypeOfHesabId=@TypeOfHesabId where GroupHesabId=@GroupHesabId" 

 runat="server"> 

 <UpdateParameters> 

 <asp:Parameter Name="GroupHesabId" Type="Int32" ></asp:Parameter> 

 <asp:Parameter Name="GroupHesabName" Type="String"></asp:Parameter> 

 <asp:Parameter Name="GroupHsabNum" Type="String"></asp:Parameter> 

 <asp:Parameter Name="TypeOfHesabId" Type="Int16"></asp:Parameter> 

 </UpdateParameters> 

 <DeleteParameters> 

 <asp:Parameter Name="GroupHesabId" Type="Int32"></asp:Parameter> 

 </DeleteParameters> 

 <InsertParameters> 

 <asp:Parameter Name="GroupHesabName" Type="String"></asp:Parameter> 

 <asp:Parameter Name="GroupHsabNum" Type="String"></asp:Parameter> 

 <asp:Parameter Name="TypeOfHesabId" Type="Int16"></asp:Parameter> 

  

 </InsertParameters> 

  

 </asp:SqlDataSource> 

 <asp:SqlDataSource ID="SqlDataSource2" ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>" 

 ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM Kol k LEFT OUTER JOIN MahiyatKol m on k.MahiyatKolID=m.MahiyatKolID Where GroupHesabId = @GroupHesabId" 

 InsertCommand="INSERT INTO Kol(KolName,KolNum,GroupHesabId,MahiyatKolID) VALUES (@KolName,@KolNum,@GroupHesabId,@MahiyatKolID)" 

 DeleteCommand="Delete from Kol where KolId=@KolId" 

 UpdateCommand ="Update Kol Set KolName=@KolName ,KolNum=@KolNum,GroupHesabId=@GroupHesabId,MahiyatKolID=@MahiyatKolID where KolId=@KolId" 

  

 runat="server"> 

 <UpdateParameters> 

 <asp:Parameter Name="KolName" Type="String"></asp:Parameter> 

 <asp:Parameter Name="KolNum" Type="String"></asp:Parameter> 

 <asp:Parameter Name="GroupHesabId" Type="Int32"></asp:Parameter> 

 <asp:Parameter Name="MahiyatKolID" Type="Int16"></asp:Parameter> 

 <asp:Parameter Name="KolId" Type="Int32"></asp:Parameter> 

 </UpdateParameters> 

 <DeleteParameters> 

 <asp:Parameter Name="KolId" Type="Int32"></asp:Parameter> 

 </DeleteParameters> 

 <InsertParameters> 

 <asp:Parameter Name="KolName" Type="String"></asp:Parameter> 

 <asp:Parameter Name="KolNum" Type="String"></asp:Parameter> 

 <asp:Parameter Name="GroupHesabId" Type="Int32"></asp:Parameter> 

 <asp:Parameter Name="MahiyatKolID" Type="Int16"></asp:Parameter> 

  

 </InsertParameters> 

 <SelectParameters> 

 <asp:SessionParameter Name="GroupHesabId" SessionField="GroupHesabId" Type="string"></asp:SessionParameter> 

 </SelectParameters> 

 </asp:SqlDataSource> 

 <asp:SqlDataSource ID="SqlDataSource3" ConnectionString="<%$ ConnectionStrings:ACCConnectionString %>" 

 ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [Moien] m LEFT OUTER JOIN MahiyatMoien mh on m.MahiyatMoinID=mh.MahiyatMoinID where KolId = @KolId" 

 InsertCommand="INSERT INTO Moien(MoienName,MoienNum,KolId,MahiyatMoinId) VALUES (@MoienName,@MoienNum,@KolId,@MahiyatMoinId)" 

 DeleteCommand="Delete from Moien where MoeinId=@MoeinId" 

 UpdateCommand ="Update Moien Set MoienName=@MoienName ,MoienNum=@MoienNum,KolId=@KolId,MahiyatMoinId=@MahiyatMoinId where MoeinId=@MoeinId" 

 runat="server"> 

 <UpdateParameters> 

 <asp:Parameter Name="MoienName" Type="String"></asp:Parameter> 

 <asp:Parameter Name="MoienNum" Type="String"></asp:Parameter> 

 <asp:Parameter Name="KolId" Type="Int32"></asp:Parameter> 

 <asp:Parameter Name="MahiyatMoinId" Type="Int16"></asp:Parameter> 

 <asp:Parameter Name="MoeinId" Type="Int32"></asp:Parameter> 

 </UpdateParameters> 

 <DeleteParameters> 

 <asp:Parameter Name="MoeinId" Type="Int32"></asp:Parameter> 

 </DeleteParameters> 

 <InsertParameters> 

 <asp:Parameter Name="MahiyatMoinId" Type="Int16"></asp:Parameter> 

 <asp:Parameter Name="MoienName" Type="String"></asp:Parameter> 

 <asp:Parameter Name="MoienNum" Type="String"></asp:Parameter> 

 <asp:Parameter Name="KolId" Type="Int32"></asp:Parameter> 

  

 </InsertParameters> 

 <SelectParameters> 

 <asp:SessionParameter Name="KolId" SessionField="KolId" Type="Int32"></asp:SessionParameter> 

 </SelectParameters> 

 </asp:SqlDataSource> 

 </div> 

 </form> 

 </asp:Content>

Thank you

2 Answers, 1 is accepted

answered on 15 Jan 2014, 01:02 PM

Hello,

From the provided code it seems that the setup is correct.

Please ensure that the SQL query returns the field that is used as a DetailKeyField in the last hierarchy level. Also try disabling Ajax on the page and see if the behavior would change.

If you could provide a runnable sample project where the problem is observed it would allow us to try replicating the issue locally. You could use a file sharing service of your choice and provide a download link. This way we would be able to investigate the problem and provide an appropriate solution.

Regards,
Viktor Tachev
Telerik

If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Extended Reality

Free Tools

hierarchy table in 4 layer not showing

2 Answers, 1 is accepted