Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
125
Child Column Headers
posted

Hi,

When I expand the child table doesn't have any visible columns/headers. Any Idea on why?

I followed the instructions on the WebHierarchicalDatagrid Videos exactly, the only difference being that my DataSources are "asp:SqlDataSource".

        <ig:WebHierarchicalDataGrid id="WebDataGrid1" runat="server" AutoGenerateBands="false" AutoGenerateColumns="false"
                                    DataKeyFields="Id" DataMember="dsDivisions_DefaultView" DataSourceID="whds" Height="350px"
                                    Key="dsDivisions_DefaultView" Width="100%" EnableTheming="True" StyleSetName="LucidDream">
            <Columns>
                <ig:BoundDataField DataFieldName="Name" DataType="system.string" Width="150px" Key="Name" Header-Text="Division Name"></ig:BoundDataField>
                <ig:BoundDataField DataFieldName="Name1" DataType="system.string" Width="150px" Key="Description" Header-Text="Division Description"></ig:BoundDataField>
                <ig:BoundDataField DataFieldName="Id" DataType="system.integer" Key="Id" Hidden="false" Header-Text="Division Id"></ig:BoundDataField>
            </Columns>                   
            <Bands>
                 <ig:Band AutoGenerateColumns="true" DataKeyFields="Id" Key="dsAssessments_DefaultView" DataMember="dsAssessments_DefaultView">
                    <Columns>
                        <ig:BoundDataField DataFieldName="SurveyName" DataType="system.string" Key="SurveyName" Header-Text="Survey Name"></ig:BoundDataField>
                        <ig:BoundDataField DataFieldName="EmployeeName" DataType="system.string" Width="200px" Key="EmployeeName" Header-Text="Employee Name"></ig:BoundDataField>
                        <ig:BoundDataField DataFieldName="DateCreated" DataType="system.datetime" Key="DateCreated" Header-Text="Date Created"></ig:BoundDataField>
                        <ig:BoundDataField DataFieldName="DateCompleted" DataType="system.datetime" Key="DateCompleted" Header-Text="Date Completed"></ig:BoundDataField>
                        <ig:BoundDataField DataFieldName="Total" DataType="system.string" Key="Total" Header-Text="Completed Assessments"></ig:BoundDataField>
                        <ig:BoundDataField DataFieldName="Team" DataType="system.string" Key="Team" Header-Text="Team Completed"></ig:BoundDataField>
                        <ig:BoundDataField DataFieldName="Peer" DataType="system.string" Key="Peer" Header-Text="Peer Completed"></ig:BoundDataField>
                        <ig:BoundDataField DataFieldName="Leader" DataType="system.string" Key="Leader" Header-Text="Leader Completed"></ig:BoundDataField>
                        <ig:BoundDataField DataFieldName="ClientInternal" DataType="system.string" Key="IntClient" Header-Text="Int Clients Completed"></ig:BoundDataField>
                        <ig:BoundDataField DataFieldName="ClientExternal" DataType="system.string" Key="ExtClient" Header-Text="Ext Clients Completed"></ig:BoundDataField>
                        <ig:BoundDataField DataFieldName="Id" DataType="system.integer" Key="Id" Header-Text="Employee Id"></ig:BoundDataField>
                        <ig:TemplateDataField Width="25px" Key="Edit">
                            <ItemTemplate>
                                <img alt="edit" onclick="ClickButton(this.parentElement.parentElement)" ID="btnEdit" src="../../Images/Icons/16/pencil_16.gif" runat="server" />                                               
                            </ItemTemplate>
                        </ig:TemplateDataField>
                    </Columns>
                </ig:Band>
            </Bands>
            <Behaviors>
                <ig:VirtualScrolling ScrollingMode="Deferred"></ig:VirtualScrolling>
                <ig:ColumnResizing></ig:ColumnResizing>
                <ig:Sorting></ig:Sorting>
                <ig:Selection CellClickAction="Row" RowSelectType="Single"></ig:Selection>
                <ig:activation></ig:activation>
            </Behaviors>
        </ig:WebHierarchicalDataGrid>
        <ig:WebHierarchicalDataSource ID="whds" runat="server">
            <DataRelations>
                <ig:DataRelation ChildColumns="DivisionId"
                    ChildDataViewID="dsAssessments_DefaultView" ParentColumns="Id"
                    ParentDataViewID="dsDivisions_DefaultView" />
            </DataRelations>
            <DataViews>
                <ig:DataView ID="dsDivisions_DefaultView" DataMember="DefaultView"
                    DataSourceID="dsDivisions" />
                <ig:DataView ID="dsAssessments_DefaultView" DataMember="DefaultView"
                    DataSourceID="dsAssessments" />
            </DataViews>
        </ig:WebHierarchicalDataSource>
        <asp:SqlDataSource ID="dsAssessments" runat="server" SelectCommandType="StoredProcedure"
            SelectCommand="[ECS].[GetAssessments]"
            ConnectionString="<%$ ConnectionStrings:###REMOVED###%>">
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="dsDivisions"  runat="server" SelectCommandType="StoredProcedure"
            SelectCommand="[dbo].[Division_GetAllDivisions]"
            ConnectionString="<%$ ConnectionStrings:###REMOVED###%>">
            <SelectParameters>
                <asp:Parameter Name="CompanyId" Type="Int32" DefaultValue="0" />
            </SelectParameters>
        </asp:SqlDataSource>