Nested ListView - How to Connect

[Angela]

How can I connect listChild to listParent using the Parent_ID?

<telerik:RadListView ID="listParent" DataKeyNames="Parent_ID" DataSourceID="sqlParent" RenderMode="Lightweight" runat="server">
    <ItemTemplate>
        ID: <%# Eval("Parent_ID") %>
        <%# Eval("Parent_Name") %>

        <telerik:RadListView ID="listChild" DataKeyNames="Parent_ID" DataSourceID="sqlChild" RenderMode="Lightweight" runat="server">
            <ItemTemplate>
                <!-- child details would go here -->
            </ItemTemplate>
        </telerik:RadListView>

        <asp:SqlDataSource ID="sqlChild" runat="server" ConnectionString="<%$ ConnectionStrings:cs %>" SelectCommand="Impact.usp_exe_get_Child" SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:Parameter Name="Parent_ID" /> <!-- Parent ID from listParent-->
            </SelectParameters>
        </asp:SqlDataSource>
    </ItemTemplate>
</telerik:RadListView>

<asp:SqlDataSource ID="sqlParent" runat="server" ConnectionString="<%$ ConnectionStrings:cs %>" SelectCommand="Impact.usp_exe_get_Parent" SelectCommandType="StoredProcedure"></asp:SqlDataSource>

[Attila Antal]

Hi Angela,

You can try using the ItemDatabound event of the ListView where you will have access to the Data key name and fetch the value, then set this value as the Parameter of the sqlChild.

Example

protected void listParent_ItemDataBound(object sender, Telerik.Web.UI.RadListViewItemEventArgs e)
{
    if(e.Item is RadListViewDataItem)
    {
        RadListViewDataItem dataItem = (RadListViewDataItem)e.Item;

        int parentId = (int)dataItem.GetDataKeyValue("Parent_ID");

        SqlDataSource sqlChild = dataItem.FindControl("sqlChild") as SqlDataSource;

        if(sqlChild != null)
        {
            sqlChild.SelectParameters["Parent_ID"].DefaultValue = parentId.ToString();
        }
    }
}

 

Regards,
Attila Antal
Progress Telerik

[Angela]

Thank you Attila. This worked perfectly!