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

Hierarchymode = "client"

7 Answers 73 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

answered on 13 Dec 2010, 02:21 PM

Hi OPL,

You should change the parameter names in the Where clauses of the select command of the data-source controls from ? to the name of the parameter with a @ sign in front:

...FROM TARIVETTST.COMPARTI WHERE NOCOMP=@NOCOMP">

TARIVETTST.COMPREM WHERE nocomp=@NOCOMP AND cdart=@CDART

Hope it helps.

Greetings,
Tsvetoslav
the Telerik team

Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

Accepted

Hierarchymode = &quot;client&quot;

7 Answers, 1 is accepted

Hierarchymode = "client"