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

Hierarchymode = "client"

7 Answers 70 Views

Grid

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

OPL asked on 13 Dec 2010, 09:32 AM

Hi,
Is anybody can explain me what's wrong in my code ?

The détailtable is always empty at the first load. If i sort the grid, détailtables are bind.

Thks

<telerik:RadGrid ID="MasterRadGrid" runat="server" AutoGenerateColumns="False" AllowPaging="True"

AllowSorting="True" GridLines="None" AllowMultiRowSelection="true" DataSourceID="DataSource1"

CssClass="data-table achat-vente" ClientSettings-AllowExpandCollapse="true">

<ClientSettings>

<Scrolling AllowScroll="true" UseStaticHeaders="true" ScrollHeight="590px" />

<Selecting AllowRowSelect="true" UseClientSelectColumnOnly="true" EnableDragToSelectRows="false" />

<ClientEvents OnGridCreated="GridCreated" />

</ClientSettings>

<HierarchySettings ExpandTooltip="Afficher les détails" CollapseTooltip="Masquer les détails" />

<SortingSettings SortToolTip="Trier" SortedAscToolTip="Trier" SortedDescToolTip="Trier" />

<ItemStyle CssClass="row1" />

<AlternatingItemStyle CssClass="row2" />

<MasterTableView CellSpacing="1" CssClass="data-table" DataSourceID="DataSource1"

HierarchyLoadMode="client" DataKeyNames="NOCOMP,CDART" ClientDataKeyNames="NOCOMP,CDART"

Name="MasterTarif">

<PagerStyle Mode="NextPrevAndNumeric" PageSizeLabelText="Nombre de lignes par page"

ShowPagerText="true" FirstPageToolTip="Première page" PrevPagesToolTip="Page précédente"

NextPagesToolTip="Page suivante" LastPageToolTip="Dernière page" PagerTextFormat="{4} Articles {2} à {3} sur {5}"

PageButtonCount="5" BackColor="#ABCD55" BorderStyle="None" VerticalAlign="Middle" />

<DetailTables>

<telerik:GridTableView Name="DetailsTarif" runat="server" Width="100%" AllowPaging="false"

AllowSorting="false" CellSpacing="1" CssClass="toggleRow row-open" DataSourceID="DataSource2"

DataKeyNames="NOCOMP,CDART" ClientDataKeyNames="NOCOMP,CDART" HierarchyLoadMode="client">

<ItemStyle CssClass="rgRow row_detail" />

<AlternatingItemStyle CssClass="rgRow row_detail" />

<ParentTableRelation>

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

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

</ParentTableRelation>

<Columns>

<telerik:GridBoundColumn UniqueName="DetailNoComp" DataField="NOCOMP" Visible="false" />

<telerik:GridBoundColumn UniqueName="DetailCodeArticle" DataField="CDART" Visible="false" />

<telerik:GridBoundColumn HeaderText="Type de remise" DataField="CODEREM">

<HeaderStyle CssClass="" Width="60px" />

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn>

<HeaderStyle CssClass="sep no_bg" Width="5px" />

<ItemStyle CssClass="sep no_bg" Width="5px" />

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn HeaderText="Nombre d'unités Centravet" DataField="QTE" UniqueName="QteCentrav">

<HeaderStyle CssClass="" Width="150px" />

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn HeaderText="Marge quantité Centravet">

<HeaderStyle CssClass="" Width="150px" />

<ItemTemplate>

<asp:Label ID="ToggleMargeQuantCentravetLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGE") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Nouvelle marge Centravet">

<HeaderStyle CssClass="" Width="150px" />

<ItemTemplate>

<asp:Label ID="ToggleNvelleMargeCentravetOldLtr" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGENW") %>'

Visible="false" />

<telerik:RadNumericTextBox ID="ToggleNvelleMargeCentravetTxt" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGENW") %>'

Columns="8" Culture="fr-FR" MaxLength="8" MinValue="0" MaxValue="99999.99" NumberFormat-DecimalDigits="2"

Width="60px" />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn>

<HeaderStyle CssClass="sep no_bg" Width="5px" />

<ItemStyle CssClass="sep no_bg" Width="5px" />

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn HeaderText="Nombre d'unités Alcyon" DataField="QTE1">

<HeaderStyle CssClass="th-detail-Al" Width="150px" />

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn HeaderText="Marge quantité Alcyon">

<HeaderStyle CssClass="th-detail-Al" Width="150px" />

<ItemTemplate>

<asp:Label ID="ToggleMargeQuantAlcyonLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGE1") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn>

<HeaderStyle CssClass="sep no_bg" Width="5px" />

<ItemStyle CssClass="sep no_bg" Width="5px" />

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn HeaderText="Nombre d'unités Coveto" DataField="QTE2">

<HeaderStyle CssClass="th-detail-Co" Width="150px" />

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn HeaderText="Marge quantité Coveto">

<HeaderStyle CssClass="th-detail-Co" Width="150px" />

<ItemTemplate>

<asp:Label ID="ToggleMargeQuantCovetoLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGE2") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn>

<HeaderStyle CssClass="sep no_bg" Width="5px" />

<ItemStyle CssClass="sep no_bg" Width="5px" />

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn HeaderText="Nombre d'unités Central x" DataField="QTE3">

<HeaderStyle CssClass="th-detail-Cx" Width="150px" />

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn HeaderText="Marge quantité Central x">

<HeaderStyle CssClass="th-detail-Cx" Width="150px" />

<ItemTemplate>

<asp:Label ID="ToggleMargeQuantXLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGE3") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn>

<HeaderStyle CssClass="sep no_bg" Width="5px" />

<ItemStyle CssClass="sep no_bg" Width="5px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="BILAN">

<HeaderStyle CssClass="" Width="150px" />

</telerik:GridTemplateColumn>

<%--Colonne supplementaire de taille variable afin d'empêcher que le tableau occupe 100% de la largeur disponible--%>

<telerik:GridTemplateColumn>

<HeaderStyle CssClass="sep no_bg" />

<ItemStyle CssClass="sep no_bg" />

</telerik:GridTemplateColumn>

</Columns>

</telerik:GridTableView>

</DetailTables>

<ExpandCollapseColumn Visible="true" ExpandImageUrl="images/expand.gif" CollapseImageUrl="images/collapse.gif"

ButtonType="ImageButton" UniqueName="ExpandColumn">

<HeaderStyle CssClass="th-achat" Width="50px" />

<ItemStyle CssClass="first" />

</ExpandCollapseColumn>

<Columns>

<telerik:GridTemplateColumn UniqueName="SelectColumn" HeaderText="Sélection">

<HeaderStyle CssClass="" Width="50px" />

<ItemTemplate>

<asp:CheckBox ID="SelectedChk" runat="server" CausesValidation="true"></asp:CheckBox>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Quantité 12 mois mobiles" SortExpression="QTESTAT">

<HeaderStyle Width="60px" CssClass="" />

<ItemTemplate>

<asp:Label ID="QuantiteLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"QTESTAT") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="CA mobile Année N" SortExpression="CASTAT">

<HeaderStyle CssClass="" Width="60px" />

<ItemTemplate>

<asp:Label ID="CaLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"CASTAT") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Marge mobile Année N" SortExpression="MARGSTAT">

<HeaderStyle CssClass="" Width="60px" />

<ItemTemplate>

<asp:Label ID="MargeLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGSTAT") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="5">

<HeaderStyle Width="3px" />

<ItemStyle CssClass="sep no_bg" Width="3px"></ItemStyle>

<ItemTemplate>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Code article" SortExpression="CDART">

<HeaderStyle CssClass="" Width="60px" />

<ItemTemplate>

<asp:Label ID="CodeArticleLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"CDART") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn HeaderText="Nom <br/>fournisseur" SortExpression="NOMFOUR"

DataField="NOMFOUR">

<HeaderStyle CssClass="" Width="100px" />

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn HeaderText="Libellé" SortExpression="LIBRED">

<HeaderStyle CssClass="" Width="300px" />

<ItemStyle CssClass="leftalign" />

<ItemTemplate>

<asp:Literal ID="LibelleArticleLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"LIBRED") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="5">

<HeaderStyle Width="3px" />

<ItemStyle CssClass="sep no_bg" Width="3px"></ItemStyle>

<ItemTemplate>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="P.U. Net" SortExpression="PUNETHA">

<HeaderStyle CssClass="th-achat" Width="45px" />

<ItemTemplate>

<asp:Label ID="PuNetLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"PUNETHA") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="5">

<HeaderStyle Width="3px" />

<ItemStyle CssClass="sep no_bg" Width="3px"></ItemStyle>

<ItemTemplate>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Marge unitaire Centravet" SortExpression="MARGEU">

<HeaderStyle CssClass="th-vente" Width="70px" />

<ItemTemplate>

<asp:Label ID="MargeUnitCentravetLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGEU") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Nouvelle marge Centravet" SortExpression="MARGENW">

<HeaderStyle CssClass="th-vente" Width="77px" />

<ItemTemplate>

<asp:Literal ID="NvelleMargeCentravetOldLtr" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGENW") %>'

Visible="false" />

<telerik:RadNumericTextBox ID="NvelleMargeCentravetTxt" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGENW") %>'

Culture="fr-FR" MaxLength="8" MinValue="-99999.999" MaxValue="99999.999" NumberFormat-DecimalDigits="3"

Width="60px" />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Marge unitaire Alcyon" SortExpression="MACONCUR1">

<HeaderStyle CssClass="th-detail-Al" Width="62px" />

<ItemTemplate>

<asp:Literal ID="MargeAlcyonLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MACONCUR1") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Marge unitaire Coveto" SortExpression="MACONCUR2">

<HeaderStyle CssClass="th-detail-Co" Width="62px" />

<ItemTemplate>

<asp:Literal ID="MargeCovetoLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MACONCUR2") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Marge unitaire Central x" SortExpression="MACONCUR3">

<HeaderStyle CssClass="th-detail-Cx" Width="70px" />

<ItemTemplate>

<asp:Literal ID="MargeXLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MACONCUR3") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<%--Colonne supplementaire de taille variable afin d'empêcher que le tableau occupe 100% de la largeur disponible--%>

<telerik:GridTemplateColumn HeaderText="5">

<HeaderStyle Width="3px" />

<ItemStyle CssClass="sep no_bg" Width="3px"></ItemStyle>

<ItemTemplate>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="BILAN">

<HeaderStyle CssClass="" Width="70px" />

<ItemTemplate>

<telerik:RadNumericTextBox ID="BilanPrincipal" runat="server" BorderStyle="none"

Culture="fr-FR" MaxLength="10" NumberFormat-DecimalDigits="2" Width="80px" BackColor="Transparent" EnabledStyle-HorizontalAlign="Center" ReadOnly="True" />

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

<asp:SqlDataSource ID="DataSource1" runat="server" ConnectionString="......."

ProviderName="System.Data.OleDb"

SelectCommand="SELECT NOCOMP, CDART, LIBRED, LIBLONG, GTIN, LIBFAM, NOMFOUR, QTESTAT, CASTAT, MARGSTAT, QTESTATP, CASTATP,

MARGSTATP, PUNETHA, PHACST, PUVTE, PUVTENW, MARGEU, MARGENW, PUCONCUR1, MACONCUR1, PUCONCUR2, MACONCUR2, PUCONCUR3, MACONCUR3

FROM TARIVETTST.COMPARTI WHERE NOCOMP=?">

<SelectParameters>

<asp:Parameter Name="NOCOMP" />

</SelectParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="DataSource2" runat="server" ConnectionString="....."

ProviderName="System.Data.OleDb"

SelectCommand="select NOCOMP, CDART, CODEREM, QTE, MARGE, PXREV, TAUX, MARGENW, PXREVNW, QTE1, MARGE1, PXREV1, QTE2, MARGE2, PXREV2,

QTE3, MARGE3, PXREV3, DATDEB, DATFIN from TARIVETTST.COMPREM WHERE nocomp=? AND cdart=?" >

<SelectParameters>

<asp:SessionParameter Name="NOCOMP" SessionField="NOCOMP" Type="String" />

<asp:SessionParameter Name="CDART" SessionField="CDART" Type="String" />

</SelectParameters>

</asp:SqlDataSource>

7 Answers, 1 is accepted

Accepted

Hierarchymode = &quot;client&quot;

7 Answers, 1 is accepted

Hierarchymode = "client"