or
I have 3 levels
Top Level - Client Job
2nd Level - JobTask
3rd Level - TaskStockRequirments
The ClentId for the TopLevel is achieved through :-
Protected Sub SqlTopLevel_Clients_Selecting(sender As Object, e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlTopLevel_Clients.Selecting If hdnClientId.Value = "" Then hdnClientId.Value = "1" e.Command.CommandText = "SELECT * FROM bm_ClientJob Where ClientId = " & CStr(hdnClientId.Value)End Suband this is ok and the Level 2 is displayed OK but I can't understand why Level 3 doesn't appear.
<%-- CLIENT JOBS HIERARCHICAL GRIDS --%> <telerik:RadSlidingPane ID="rspClientJobs" Title="Client Jobs" runat="server" Height="650px"> <telerik:RadFormDecorator ID="QsfFromDecorator" runat="server" DecoratedControls="All" EnableRoundedCorners="false" /> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="grdClientJobs"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="grdClientJobs"></telerik:AjaxUpdatedControl> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadGrid ID="grdClientJobs" OnPreRender="grdClientJobs_PreRender" ShowStatusBar="True" DataSourceID="SqlTopLevel_Clients" runat="server" AutoGenerateColumns="False" PageSize="7" AllowSorting="True" AllowPaging="True" GridLines="None" CellSpacing="0"> <PagerStyle Mode="NumericPages"></PagerStyle> <MasterTableView DataSourceID="SqlTopLevel_Clients" DataKeyNames="JobId" AllowMultiColumnSorting="True" HierarchyLoadMode="Client" Width="100%"> <DetailTables> <telerik:GridTableView DataKeyNames="JobId" DataSourceID="SqlLevel2_ClientJobs" Width="100%" runat="server"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="JobId" MasterKeyField="JobId"> </telerik:GridRelationFields> </ParentTableRelation> <%--LEVEL 3 GRID TABLE - JOBTASKS COLUMNS--%> <DetailTables> <telerik:GridTableView DataKeyNames="TaskId" DataSourceID="SqlLevel3_ClientJobTasks" Width="100%" runat="server"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="TaskId" MasterKeyField="TaskId"></telerik:GridRelationFields> </ParentTableRelation> <Columns> <telerik:GridBoundColumn SortExpression="Requirement" HeaderText="Requirement" HeaderButtonType="TextButton" DataField="Requirement" UniqueName="Requirement"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="Supplier" HeaderText="Supplier" HeaderButtonType="TextButton" DataField="Supplier" UniqueName="Supplier"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="Amount" HeaderText="Amount" HeaderButtonType="TextButton" DataField="Amount" UniqueName="Amount"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="Units" HeaderText="Units" HeaderButtonType="TextButton" DataField="Units" UniqueName="Units"> </telerik:GridBoundColumn> </Columns> <SortExpressions> <telerik:GridSortExpression FieldName="TaskName" SortOrder="Descending"></telerik:GridSortExpression> </SortExpressions> </telerik:GridTableView> </DetailTables> <%--LEVEL 2 GRID TABLE - CLIENT JOB COLUMNS--%> <Columns> <telerik:GridBoundColumn SortExpression="TaskId" HeaderText="Task Id" HeaderButtonType="TextButton" DataField="TaskId" UniqueName="TaskId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="TaskSeqNo" HeaderText="Seq No" HeaderButtonType="TextButton" DataField="TaskSeqNo" UniqueName="TaskSeqNo"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="TaskName" HeaderText="Name" HeaderButtonType="TextButton" DataField="TaskName" UniqueName="TaskName"> </telerik:GridBoundColumn> </Columns> <SortExpressions> <telerik:GridSortExpression FieldName="TaskName" SortOrder="Descending"></telerik:GridSortExpression> </SortExpressions> </telerik:GridTableView> </DetailTables> <%--TOP LEVEL CLIENT COLUMNS--%> <Columns> <telerik:GridBoundColumn SortExpression="JobId" HeaderText="JobId" HeaderButtonType="TextButton" DataField="JobId" UniqueName="JobId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="StartDate" HeaderText="Date Start" HeaderButtonType="TextButton" DataField="StartDate" UniqueName="StartDate" DataFormatString="{0:D}"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="JobName" HeaderText="Name" HeaderButtonType="TextButton" DataField="JobName" UniqueName="JobName"> </telerik:GridBoundColumn> </Columns> </MasterTableView> </telerik:RadGrid> <%--HIERARCHICAL GRIDS SQL DATA SOURCES--%> <asp:SqlDataSource ID="SqlTopLevel_Clients" ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM bm_ClientJob Where ClientId = @ClientId" runat="server"> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlLevel2_ClientJobs" ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM bm_JobTask where JobId = @JobId Order By TaskSeqNo" runat="server"> <SelectParameters> <asp:SessionParameter Name="JobId" SessionField="JobId" Type="Int32"></asp:SessionParameter> </SelectParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlLevel3_ClientJobTasks" ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM bm_TaskStockRequirement where TaskId = @TaskId" runat="server"> <SelectParameters> <asp:SessionParameter Name="TaskId" SessionField="TaskId" Type="Int32"></asp:SessionParameter> </SelectParameters> </asp:SqlDataSource>
Any ideas please?
<!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title> <script type="text/javascript"> function openRadWindow() { var oWnd = radopen("/parts/test.aspx", "RadWindow1"); oWnd.setSize(850, 700); oWnd.center(); } </script></head><body> <form id="form1" runat="server"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> </telerik:RadScriptManager> <asp:DropDownList ID="lstComponent" runat="server" /> <asp:Button ID="btnReload" runat="server" OnClick="btnReload_Click" /> <asp:Button ID="btnAddNew" runat="server" Text="Add New" OnClientClick="openRadWindow('', '', '', ''); return false;" CssClass="button small green" /> <telerik:RadWindowManager ShowContentDuringLoad="false" EnableShadow="true" InitialBehaviors="Maximize" ID="RadWindowManager1" runat="server" Behaviors="Close" > </telerik:RadWindowManager> </form></body></html>protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { lstComponent.Items.Clear(); lstComponent.Items.Insert(0, new ListItem(QA.BLL.Common.Const.please_select, String.Empty)); } }<!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title> <script type="text/javascript"> function CloseAndRebind(args) { //GetRadWindow().BrowserWindow.refreshGrid(args); GetRadWindow().close(); } function GetRadWindow() { var oWindow = null; if (window.radWindow) oWindow = window.radWindow; //Will work in Moz in all cases, including clasic dialog else if (window.frameElement.radWindow) oWindow = window.frameElement.radWindow; //IE (and Moz as well) return oWindow; } function CancelEdit() { GetRadWindow().close(); }</script></head><body> <form id="form1" runat="server"> <div> <asp:Button ID="Button1" runat="server" Text="Nothing" OnClick="Button1_Click" /> <asp:Button ID="btnTest" runat="server" OnClick="btnTest_Click" /> </div> </form></body></html>public partial class test : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void btnTest_Click(object sender, EventArgs e) { int test = 1; Page.ClientScript.RegisterStartupScript(Page.GetType(), "mykey", "CloseAndRebind('Rebind');", true); } protected void Button1_Click(object sender, EventArgs e) { btnTest.Text = DateTime.Now.ToShortTimeString(); } }<telerik:RadWindow ID="RadWindowCard" runat="server" AutoSize="true" IconUrl="/image/iconlogo.png" ReloadOnShow="True" NavigateUrl="publicard.aspx" Behaviors="Close" RestrictionZoneID="NavigateUrlZone" Height="100" Skin="Office2010Silver" VisibleStatusbar="false" Title="Caricamento biglietto da visita..." ShowContentDuringLoad="False" Width="300" Modal="true" KeepInScreenBounds="true" Style="z-index: 8000"></telerik:RadWindow><form id="form1" runat="server"> <div> <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="ImageButtonRicerca"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="Panel1" LoadingPanelID="RadAjaxLoadingPanel1" /> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="RadListView1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadWindowCard" LoadingPanelID="RadAjaxLoadingPanel1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <asp:HiddenField ID="_search" runat="server" /><asp:HiddenField ID="_search1" runat="server" /> <telerik:RadWindow ID="RadWindowCard" runat="server" AutoSize="true" IconUrl="/image/iconlogo.png" ReloadOnShow="True" NavigateUrl="publicard.aspx" Behaviors="Close" RestrictionZoneID="NavigateUrlZone" Height="100" Skin="Office2010Silver" VisibleStatusbar="false" Title="Caricamento biglietto da visita..." ShowContentDuringLoad="False" Width="300" Modal="true" KeepInScreenBounds="true" Style="z-index: 8000"> </telerik:RadWindow> <telerik:RadFormDecorator ID="RadFormDecorator" Runat="server" DecoratedControls="Default, Textbox, Textarea, Label, H4H5H6, Select, Zone, GridFormDetailsViews, ValidationSummary, LoginControls" Skin="Sunset" /> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" Runat="server" BorderColor="#D5842B" BorderStyle="Double" BorderWidth="1px" Skin="Simple"> </telerik:RadAjaxLoadingPanel> <div align="center" class="backgroundup"> <div align="center" class="banner"> <div style="padding-left:200px;"> <div class="profilesearch"> <asp:Panel ID="Panel1" runat="server" DefaultButton="ImageButtonRicerca" Height="55px" Width="685"> <div id="txt1" style="width:350px; height:22px; border:0px; margin:0px; padding-top:15px; padding-right:1px; float:left"> <telerik:RadTextBox ID="Txt_ricerca1" Runat="server" EmptyMessage="Nominativo o azienda o categoria" Width="350px" Height="22px" Skin="" Font-Italic="True" Font-Names="Verdana"> <EmptyMessageStyle ForeColor="Gray" Font-Italic="True" Font-Names="Verdana" /> <HoveredStyle Font-Italic="True" Font-Names="Verdana" ForeColor="#993300" /> </telerik:RadTextBox> </div> <div id="txt2" style="width:250px; height:22px; border:0px; margin:0px; padding-top:15px; padding-right:1px; float:left"> <telerik:RadTextBox ID="txt_ricerca2" runat="server" EmptyMessage="Città di residenza" Width="250px" Height="22px" Skin="" Font-Italic="True" Font-Names="Verdana"> <EmptyMessageStyle ForeColor="Gray" Font-Italic="True" Font-Names="Verdana" /> <HoveredStyle Font-Italic="True" Font-Names="Verdana" ForeColor="#993300" /> </telerik:RadTextBox> </div> <div id="btn" style="width:80px; height:40px; border:0px; margin:0px; padding-top:7px; float:right"> <asp:ImageButton ID="ImageButtonRicerca" runat="server" ImageUrl="~/Image/cerca.png" /> </div> </asp:Panel> </div> </div> <div id="menu" class="divresultmenu"> <div id="lbresult" class="lbresult"> <asp:Label ID="Label1" runat="server" Text="Biglietti da visita trovati:" style="font-size: small; font-family: Verdana"></asp:Label> </div> <!-- end div lbresult --> <div class="divbuttonmenu"> <telerik:RadButton ID="btnhome" runat="server" Text="Home page"> </telerik:RadButton> <telerik:RadButton ID="btnreg" runat="server" Text="Registrati in trycontact"> </telerik:RadButton> </div> </div> <!-- end div menu --> <div class="resultseparator"> </div> <!-- end div separator --> <asp:Panel ID="PanelRadlist" runat="server" Width="700px"> <div id="div_radlistview" class="divradlistview"> <telerik:RadListView ID="RadListView1" runat="server" DataKeyNames="idutente" ItemPlaceholderID="Contenitore" AllowPaging="True" Width="650px" OnNeedDataSource="RadListView1_NeedDataSource"> <LayoutTemplate> <fieldset style="width: 700px; border:0px" id="FieldSet1"> <legend></legend> <asp:Panel ID="Contenitore" runat="server"> </asp:Panel> <telerik:RadDataPager ID="RadDataPager1" runat="server" PagedControlID="RadListView1" Width="700px" Culture="it-IT" BackColor ="#ecede5"> <Fields> <telerik:RadDataPagerButtonField FieldType="FirstPrev"></telerik:RadDataPagerButtonField> <telerik:RadDataPagerButtonField FieldType="Numeric"></telerik:RadDataPagerButtonField> <telerik:RadDataPagerButtonField FieldType="NextLast"></telerik:RadDataPagerButtonField> </Fields> </telerik:RadDataPager> </fieldset> </LayoutTemplate> <ItemTemplate> <div class="item"> <div class="image"> <asp:Image ID="Image1" runat="server" ImageUrl='<%# CType(Container.DataItem, PropertyUtente).imageprofile%>' Height="120px" Width="110px"/> </div> <div class="content"> <div class="user"> <b><%# CType(Container.DataItem, PropertyUtente).utente%></b> </div> <div class="description_category"> Categoria: <%# CType(Container.DataItem, PropertyUtente).Desccategoria%> </div> <div class="description_city"> Città : <%# CType(Container.DataItem, PropertyUtente).Desccomune%></div> <div class="description_phone"> Telefono: <%# CType(Container.DataItem, PropertyUtente).Telefono%></div> <div class="description_email"> Email: <%# CType(Container.DataItem, PropertyUtente).Email%> </div> <div class="item_button"> <telerik:RadButton ID="RadButton1" runat="server" Text="Biglietto completo" Width="150px" OnClick="RadButton1_Click"> <Icon PrimaryIconCssClass="rbOpen"></Icon> </telerik:RadButton> </div> </div> </div> </ItemTemplate> </telerik:RadListView> </div> <!-- end div radlist --> </asp:Panel> </div> <!-- end div banner --> </div> <!-- end div background --> </div> </form><
body>
<form id="form1" runat="server">
<div>
<telerik:RadTreeView ID="RadTreeView1" runat="server">
</telerik:RadTreeView>
</div>
</form>
</
body>