[Solved] More DataSource in NestedView?

[Grzesiek]

I have Grid and in this Grid I have another one.

After expand first and the second I want to have few repeaters with different DataSource, based on parameter from second Grid.

How to do this?

Now I have something like this:

    <div>
        <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
        </telerik:RadScriptManager>
        <asp:Button ID="Button1" runat="server" Text="Button" />
    </div>
    <telerik:RadGrid ID="kraje" DataSourceID="eAPI_list_countries" runat="server" AutoGenerateColumns="False"
        AllowSorting="True" AllowPaging="True" PageSize="100" GridLines="None">
        <MasterTableView DataSourceID="eAPI_list_countries" DataKeyNames="country_id">
            <ExpandCollapseColumn Visible="True">
            </ExpandCollapseColumn>
            <Columns>
                <telerik:GridTemplateColumn DataField="name" DataType="System.String" HeaderText="Kraj"
                    ReadOnly="True" SortExpression="name" UniqueName="name">
                    <ItemTemplate>
                        <a href='<%#"http://www.erepublik.com/en/country/" & Eval("permalink") %>' target="_blank">
                            <%#Eval("name")%></a>
                    </ItemTemplate>
                </telerik:GridTemplateColumn>
                <telerik:GridBoundColumn DataField="total_citizens" DataType="System.Int64" HeaderText="Populacja"
                    ReadOnly="True" SortExpression="total_citizens" UniqueName="total_citizens">
                </telerik:GridBoundColumn>
                <telerik:GridTemplateColumn DataField="citizen_fee" DataType="System.Decimal" HeaderText="Becikowe"
                    ReadOnly="True" SortExpression="citizen_fee" UniqueName="citizen_fee">
                    <ItemTemplate>
                        <%# Eval("citizen_fee") %>
                        <%#Eval("currency")%>
                    </ItemTemplate>
                </telerik:GridTemplateColumn>
                <telerik:GridBoundColumn DataField="continent" DataType="System.String" HeaderText="Kontynent"
                    ReadOnly="True" SortExpression="continent" UniqueName="continent">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="new_citizens_today" DataType="System.Int64" HeaderText="Niemowlaków dzisiaj"
                    ReadOnly="True" SortExpression="new_citizens_today" UniqueName="new_citizens_today">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="average_citizen_level" DataType="System.Int64"
                    HeaderText="Średnie EXP" ReadOnly="True" SortExpression="average_citizen_level"
                    UniqueName="average_citizen_level">
                </telerik:GridBoundColumn>
            </Columns>
            <NestedViewSettings DataSourceID="eAPI_list_regions">
                <ParentTableRelation>
                    <telerik:GridRelationFields DetailKeyField="country_id" MasterKeyField="country_id" />
                </ParentTableRelation>
            </NestedViewSettings>
            <NestedViewTemplate>
                <telerik:RadGrid ID="regiony" runat="server" DataSourceID="eAPI_list_regions">
                    <MasterTableView DataSourceID="eAPI_list_regions" DataKeyNames="region_id" AutoGenerateColumns="false">
                        <Columns>
                            <telerik:GridTemplateColumn DataField="region_name" DataType="System.String" HeaderText="Region"
                                ReadOnly="True" SortExpression="region_name" UniqueName="region_name">
                                <ItemTemplate>
                                    <a href='<%#"http://www.erepublik.com/en/region/" & Eval("permalink") %>' target="_blank">
                                        <%#Eval("region_name")%></a>
                                </ItemTemplate>
                            </telerik:GridTemplateColumn>
                            <telerik:GridBoundColumn DataField="population" DataType="System.Int64" HeaderText="Populacja"
                                ReadOnly="True" SortExpression="population" UniqueName="population">
                            </telerik:GridBoundColumn>
                        </Columns>
                        <NestedViewSettings DataSourceID="eAPI_list_constructions">
                            <ParentTableRelation>
                                <telerik:GridRelationFields DetailKeyField="region_id" MasterKeyField="region_id" />
                            </ParentTableRelation>
                        </NestedViewSettings>
                        <NestedViewTemplate>
                            <fieldset style="padding: 10px; width: 300px;">
                                <legend style="padding: 5px;"><b>Konstrukcje:&nbsp; &nbsp;</a></b></legend>
                                <asp:Repeater ID="regions_repeater" runat="server" DataSourceID="eAPI_list_constructions">
                                    <ItemTemplate>
                                        <div>
                                            <table>
                                                <tbody>
                                                    <tr>
                                                        <td>
                                                            <asp:Label ID="conId" Text='<%#Eval("construction_id") %>' runat="server"></asp:Label>:
                                                            <asp:Label ID="conQuality" Text='<%#Eval("construction_quality") %>' runat="server"></asp:Label>
                                                        </td>
                                                    </tr>
                                                </tbody>
                                            </table>
                                        </div>
                                    </ItemTemplate>
                                </asp:Repeater>
                            </fieldset>
                        </NestedViewTemplate>
                    </MasterTableView>
                </telerik:RadGrid>
            </NestedViewTemplate>
        </MasterTableView>
    </telerik:RadGrid>
    <asp:SqlDataSource ID="eAPI_list_countries" runat="server" ConnectionString="<%$ ConnectionStrings:DbSqlConnection %>"
        SelectCommand="SELECT * FROM [erepublik_eAPI_Countries]"></asp:SqlDataSource>
    <asp:SqlDataSource ID="eAPI_list_regions" runat="server" ConnectionString="<%$ ConnectionStrings:DbSqlConnection %>"
        SelectCommand="SELECT * FROM [erepublik_eAPI_Regions] WHERE ([country_id] = @country_id)">
        <SelectParameters>
            <asp:Parameter Name="country_id" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="eAPI_list_constructions" runat="server" ConnectionString="<%$ ConnectionStrings:DbSqlConnection %>"
        SelectCommand="SELECT id, region_id, construction_id, construction_quality FROM dbo.erepublik_eAPI_Regions_Constructions WHERE (region_id = @region_id)">
        <SelectParameters>
            <asp:Parameter Name="region_id" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="eAPI_list_raws" runat="server" ConnectionString="<%$ ConnectionStrings:DbSqlConnection %>"
        SelectCommand="SELECT * FROM [erepublik_eAPI_Regions_Raw_Materials] WHERE ([region_id] = @region_id)">
        <SelectParameters>
            <asp:Parameter Name="region_id" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>

Can anyone help me?

[Grzesiek]

Any ideas?

Explain - I want to have two or more repeaters in RadGrid "regiony" which is nested in first RadGrid "kraje".

[Iana Tsolova]

Hello Grzesiek,

In order to achieve your goal, you can try placing the datasource for the repeater in the NestedViewTemplate. Thus you would be able to set the value of the select parameter as desired. Please review this online demo and see how this is done there.

I hope this helps.

Regards,
Iana
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Ken Miller]

I have tried adding the datasources to the nestedviewtemplate but I get the following error:

The DataSourceID of 'RadGrid1' must be the ID of a control of type IDataSource.  A control with ID 'LinqDataSource1' could not be found.

here is my markup

<div>
            <telerik:RadGrid ID="ItemGrid" runat="server" AllowAutomaticDeletes="True" AllowAutomaticInserts="True"
                AllowAutomaticUpdates="True" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True"
                DataSourceID="ItemsLDS" GridLines="None" Skin="WebBlue" AllowPaging="True">
                <MasterTableView AutoGenerateColumns="False" DataKeyNames="ItemID" DataSourceID="ItemsLDS"
                    CommandItemDisplay="Top">
                    <RowIndicatorColumn>
                        <HeaderStyle Width="20px"></HeaderStyle>
                    </RowIndicatorColumn>
                    <%--<DetailTables>
                        <telerik:GridTableView runat="server" DataKeyNames="ImageID" DataSourceID="ImagesLDS"
                            Name="Images" AutoGenerateColumns="False" Width="400px" CellPadding="10" CommandItemDisplay="Bottom"
                            EditMode="InPlace">
                            <RowIndicatorColumn>
                                <HeaderStyle Width="20px" />
                            </RowIndicatorColumn>
                            <ParentTableRelation>
                                <telerik:GridRelationFields DetailKeyField="ItemID" MasterKeyField="ItemID" />
                            </ParentTableRelation>
                            <ExpandCollapseColumn>
                                <HeaderStyle Width="20px" />
                            </ExpandCollapseColumn>
                            <CommandItemSettings AddNewRecordText="Add New Image" />
                            <Columns>
                                <telerik:GridTemplateColumn DataField="ImageURL" HeaderText="Image" UniqueName="column1">
                                    <EditItemTemplate>
                                        <asp:TextBox runat="server" ID="TextBox1" Text='<%# Bind("ImageURL") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                    <ItemTemplate>
                                        <asp:Image ID="Image1" ImageUrl='<%# Eval("ImageURL") %>' AlternateText='<%# Eval("Description") %>'
                                            runat="server" Height="50" Width="50" />
                                    </ItemTemplate>
                                </telerik:GridTemplateColumn>
                                <telerik:GridBoundColumn DataField="Description" HeaderText="Description" UniqueName="column">
                                </telerik:GridBoundColumn>
                            </Columns>
                        </telerik:GridTableView>
                        <telerik:GridTableView runat="server" DataKeyNames="ItemChoiceID" DataSourceID="ItemChoiceLDS"
                            Name="ItemChoices" CommandItemDisplay="Bottom" EditMode="InPlace" AllowAutomaticDeletes="True"
                            AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AutoGenerateColumns="False"
                            Width="400px">
                            <RowIndicatorColumn>
                                <HeaderStyle Width="20px" />
                            </RowIndicatorColumn>
                            <DetailTables>
                                <telerik:GridTableView runat="server" DataKeyNames="ChoiceID" DataSourceID="ChoiceLDS"
                                    AutoGenerateColumns="False" CommandItemDisplay="Bottom" EditMode="InPlace">
                                    <RowIndicatorColumn>
                                        <HeaderStyle Width="20px" />
                                    </RowIndicatorColumn>
                                    <ParentTableRelation>
                                        <telerik:GridRelationFields DetailKeyField="ItemChoiceID" MasterKeyField="ItemChoiceID" />
                                    </ParentTableRelation>
                                    <ExpandCollapseColumn>
                                        <HeaderStyle Width="20px" />
                                    </ExpandCollapseColumn>
                                    <CommandItemSettings AddNewRecordText="Add New" />
                                    <Columns>
                                        <telerik:GridBoundColumn DataField="Name" HeaderText="Name" UniqueName="column1">
                                        </telerik:GridBoundColumn>
                                        <telerik:GridTemplateColumn DataField="ImageURL" HeaderText="Image" UniqueName="column">
                                            <EditItemTemplate>
                                                <asp:TextBox ID="ImageURLTextBox" runat="server" Text='<%# Bind("ImageURL") %>'></asp:TextBox>
                                            </EditItemTemplate>
                                            <ItemTemplate>
                                                <asp:Image ID="Image1" ImageUrl='<%# Eval("ImageURL") %>' runat="server" Height="20"
                                                    Width="20" />
                                            </ItemTemplate>
                                        </telerik:GridTemplateColumn>
                                    </Columns>
                                </telerik:GridTableView>
                            </DetailTables>
                            <ParentTableRelation>
                                <telerik:GridRelationFields DetailKeyField="ItemID" MasterKeyField="ItemID" />
                            </ParentTableRelation>
                            <CommandItemSettings AddNewRecordText="Add New Choice" />
                            <ExpandCollapseColumn Visible="True">
                            </ExpandCollapseColumn>
                            <Columns>
                                <telerik:GridBoundColumn DataField="Name" UniqueName="column" HeaderText="Choice">
                                </telerik:GridBoundColumn>
                            </Columns>
                        </telerik:GridTableView>
                        <telerik:GridTableView runat="server" AutoGenerateColumns="False" CommandItemDisplay="Bottom"
                            DataKeyNames="OptionID" DataSourceID="OptionLDS" EditMode="InPlace" Width="400px">
                            <ParentTableRelation>
                                <telerik:GridRelationFields DetailKeyField="ItemID" MasterKeyField="ItemID" />
                            </ParentTableRelation>
                            <CommandItemSettings AddNewRecordText="Add New Option" />
                            <Columns>
                                <telerik:GridBoundColumn DataField="Name" HeaderText="Option" UniqueName="column">
                                </telerik:GridBoundColumn>
                            </Columns>
                        </telerik:GridTableView>
                        <telerik:GridTableView runat="server" AutoGenerateColumns="False" CommandItemDisplay="Bottom"
                            DataKeyNames="PriceBreakID" DataSourceID="PriceBreakLDS" EditMode="InPlace" Width="400px">
                            <RowIndicatorColumn>
                                <HeaderStyle Width="20px" />
                            </RowIndicatorColumn>
                            <ParentTableRelation>
                                <telerik:GridRelationFields DetailKeyField="ItemID" MasterKeyField="ItemID" />
                            </ParentTableRelation>
                            <CommandItemSettings AddNewRecordText="Add New Price Break" />
                            <ExpandCollapseColumn>
                                <HeaderStyle Width="20px" />
                            </ExpandCollapseColumn>
                            <Columns>
                                <telerik:GridBoundColumn DataField="Quantity" HeaderText="Quantity" UniqueName="column1">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="Price" DataFormatString="{0:c}" HeaderText="Price"
                                    UniqueName="column">
                                </telerik:GridBoundColumn>
                            </Columns>
                        </telerik:GridTableView>
                    </DetailTables>--%>
                    <%--<NestedViewSettings DataSourceID="ImagesLDS">
                        <ParentTableRelation>
                            <telerik:GridRelationFields DetailKeyField="ItemID" MasterKeyField="ItemID" />
                        </ParentTableRelation>
                    </NestedViewSettings>--%>
                    <NestedViewTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("ItemID") %>' Visible="False"></asp:Label>
                        <telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="LinqDataSource1"
                            GridLines="None">
                            <MasterTableView DataSourceID="LinqDataSource1" AutoGenerateColumns="False"
                                DataKeyNames="ImageID">
                                <RowIndicatorColumn>
                                    <HeaderStyle Width="20px" />
                                </RowIndicatorColumn>
                                <ExpandCollapseColumn>
                                    <HeaderStyle Width="20px" />
                                </ExpandCollapseColumn>
                                <Columns>
                                    <telerik:GridBoundColumn DataField="ImageID" DataType="System.Int32"
                                        HeaderText="ImageID" ReadOnly="True" SortExpression="ImageID"
                                        UniqueName="ImageID">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="ItemID" DataType="System.Int32"
                                        HeaderText="ItemID" SortExpression="ItemID" UniqueName="ItemID">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="Description" HeaderText="Description"
                                        SortExpression="Description" UniqueName="Description">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="ImageURL" HeaderText="ImageURL"
                                        SortExpression="ImageURL" UniqueName="ImageURL">
                                    </telerik:GridBoundColumn>
                                </Columns>
                            </MasterTableView>
                        </telerik:RadGrid>
                        <asp:LinqDataSource ID="LinqDataSource1" runat="server"
                            ContextTypeName="CatalystDataContext" TableName="Images"
                            Where="ItemID == @ItemID">
                            <WhereParameters>
                                <asp:ControlParameter ControlID="Label1" Name="ItemID" PropertyName="Text"
                                    Type="Int32" />
                            </WhereParameters>
                        </asp:LinqDataSource>
                        <telerik:RadGrid ID="RadGrid2" runat="server" DataSourceID="LinqDataSource2"
                            GridLines="None">
                            <MasterTableView DataSourceID="LinqDataSource2" AutoGenerateColumns="False"
                                DataKeyNames="ItemChoiceID">
                                <RowIndicatorColumn>
                                    <HeaderStyle Width="20px" />
                                </RowIndicatorColumn>
                                <ExpandCollapseColumn>
                                    <HeaderStyle Width="20px" />
                                </ExpandCollapseColumn>
                                <Columns>
                                    <telerik:GridBoundColumn DataField="ItemChoiceID" DataType="System.Int32"
                                        HeaderText="ItemChoiceID" ReadOnly="True" SortExpression="ItemChoiceID"
                                        UniqueName="ItemChoiceID">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="ItemID" DataType="System.Int32"
                                        HeaderText="ItemID" SortExpression="ItemID" UniqueName="ItemID">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="Name" HeaderText="Name"
                                        SortExpression="Name" UniqueName="Name">
                                    </telerik:GridBoundColumn>
                                </Columns>
                            </MasterTableView>
                        </telerik:RadGrid>
                        <asp:LinqDataSource ID="LinqDataSource2" runat="server"
                            ContextTypeName="CatalystDataContext" TableName="ItemChoices"
                            Where="ItemID == @ItemID">
                            <WhereParameters>
                                <asp:ControlParameter ControlID="Label1" Name="ItemID" PropertyName="Text"
                                    Type="Int32" />
                            </WhereParameters>
                        </asp:LinqDataSource>
                    </NestedViewTemplate>
                    <CommandItemSettings AddNewRecordText="Add New Item" />
                    <ExpandCollapseColumn Visible="True">
                    </ExpandCollapseColumn>
                    <Columns>
                        <telerik:GridBoundColumn DataField="ItemID" DataType="System.Int32" HeaderText="ItemID"
                            ReadOnly="True" SortExpression="ItemID" UniqueName="ItemID">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Name" HeaderText="Name" SortExpression="Name"
                            UniqueName="Name">
                        </telerik:GridBoundColumn>
                        <telerik:GridTemplateColumn DataField="Description" HeaderText="Description" SortExpression="Description"
                            UniqueName="Description">
                            <EditItemTemplate>
                                <telerik:RadEditor ID="RadEditor1" runat="server" Content='<%# Bind("Description") %>'
                                    Skin="WebBlue">
                                    <Content>
                                    </Content>
                                </telerik:RadEditor>
                            </EditItemTemplate>
                            <ItemTemplate>
                                <asp:Label ID="DescriptionLabel" runat="server" Text='<%# Eval("Description") %>'></asp:Label>
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridCheckBoxColumn DataField="HasMascot" DataType="System.Boolean" HeaderText="HasMascot"
                            SortExpression="HasMascot" UniqueName="HasMascot">
                        </telerik:GridCheckBoxColumn>
                        <telerik:GridBoundColumn DataField="FactoryID" HeaderText="Item #" SortExpression="FactoryID"
                            UniqueName="FactoryID">
                        </telerik:GridBoundColumn>
                        <telerik:GridTemplateColumn DataField="CategoryID" DataType="System.Int32" HeaderText="Category"
                            SortExpression="CategoryID" UniqueName="CategoryID">
                            <EditItemTemplate>
                                <telerik:RadComboBox ID="RadComboBox1" runat="server" DataSourceID="CategoriesLDS"
                                    DataTextField="Name" DataValueField="CategoryID" SelectedValue='<%# Bind("CategoryID") %>'
                                    Skin="WebBlue">
                                </telerik:RadComboBox>
                            </EditItemTemplate>
                            <ItemTemplate>
                                <asp:Label ID="CategoryIDLabel" runat="server" Text='<%# Eval("Category.Name") %>'></asp:Label>
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>
                    </Columns>
                </MasterTableView>
            </telerik:RadGrid>
        </div>

The datasource is clearly there, I do not understand why it is not being found.

[Iana Tsolova]

Hello Ken,

Try moving the LinqDataSource control declaration before this of the RadGrid control in the NestedViewTemplate and see if it makes any difference:

<NestedViewTemplate>
    <asp:Label ID="Label1" runat="server" Text='<%# Eval("ItemID") %>' Visible="False">
    </asp:Label>
    <asp:LinqDataSource ID="LinqDataSource1" runat="server"
        ContextTypeName="CatalystDataContext" TableName="Images" Where="ItemID == @ItemID">
        <WhereParameters>
            <asp:ControlParameter ControlID="Label1" Name="ItemID" PropertyName="Text"
                Type="Int32" />
        </WhereParameters>
    </asp:LinqDataSource>
    <telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="LinqDataSource1"
        GridLines="None">
        <MasterTableView DataSourceID="LinqDataSource1"
            AutoGenerateColumns="False" DataKeyNames="ImageID">
            <Columns>
                <telerik:GridBoundColumn DataField="ImageID" DataType="System.Int32"
                    HeaderText="ImageID" ReadOnly="True" SortExpression="ImageID"
                    UniqueName="ImageID"></telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="ItemID" DataType="System.Int32"
                    HeaderText="ItemID" SortExpression="ItemID"
                    UniqueName="ItemID"></telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="Description" HeaderText="Description"
                    SortExpression="Description" UniqueName="Description">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="ImageURL" HeaderText="ImageURL"
                    SortExpression="ImageURL" UniqueName="ImageURL">
                </telerik:GridBoundColumn>
            </Columns>
        </MasterTableView>
    </telerik:RadGrid>
    <asp:LinqDataSource ID="LinqDataSource2" runat="server"
        ContextTypeName="CatalystDataContext" TableName="ItemChoices"
        Where="ItemID == @ItemID">
        <WhereParameters>
            <asp:ControlParameter ControlID="Label1" Name="ItemID"
               PropertyName="Text" Type="Int32" />
        </WhereParameters>
    </asp:LinqDataSource>
    <telerik:RadGrid ID="RadGrid2" runat="server" DataSourceID="LinqDataSource2"
        GridLines="None">
        <MasterTableView DataSourceID="LinqDataSource2" AutoGenerateColumns="False"
            DataKeyNames="ItemChoiceID">
            <Columns>
                <telerik:GridBoundColumn DataField="ItemChoiceID" DataType="System.Int32"
                    HeaderText="ItemChoiceID" ReadOnly="True"
                    SortExpression="ItemChoiceID" UniqueName="ItemChoiceID">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="ItemID" DataType="System.Int32"
                    HeaderText="ItemID" SortExpression="ItemID" UniqueName="ItemID">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="Name" HeaderText="Name"
                    SortExpression="Name" UniqueName="Name">
                </telerik:GridBoundColumn>
            </Columns>
        </MasterTableView>
    </telerik:RadGrid>
</NestedViewTemplate>

Sincerely yours,
Iana
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Ken Miller]

Now my problem is that I can not get the parent grid's datakey for an insert.

I have tried to use the insert parameter on the datasource:

<NestedViewTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("ItemID") %>' Visible="False"></asp:Label>
                        <asp:LinqDataSource ID="ImagesLDS" runat="server" ContextTypeName="CatalystDataContext"
                            TableName="Images" Where="ItemID == @ItemID" EnableDelete="True" EnableInsert="True"
                            EnableUpdate="True" OnInserting="ImagesLDS_Inserting1">
                            <WhereParameters>
                                <asp:ControlParameter ControlID="Label1" Name="ItemID" PropertyName="Text" Type="Int32" />
                            </WhereParameters>
                            <InsertParameters>
                                <asp:ControlParameter ControlID="Label1" Name="ItemID" PropertyName="Text" Type="Int32" />
                            </InsertParameters>
                        </asp:LinqDataSource>

But this fails.  If I add a default value, it works. but that obviously isn't helpful

[Iana Tsolova]

Hello Ken,

I can see you are saving the parent table ItemId in the lable control. Can you check what is its value on InsertCommand of the particular nested grid? Or does the insertion work if instead of setting DefaultValue to the inster parameter you hardcode the ItemID in the Label1 Text property?

Greetings,
Iana
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.