Load On Demand RadComboBox inside an EditItemTemplate of RadGrid

 Dim cmdItem As GridItem = RadGrid1.MasterTableView.GetItems(GridItemType.CommandItem)(0)
        Dim ddl As DropDownList = TryCast(cmdItem.FindControl("rcb_vehicleModel"), DropDownList)
        ddl.Items.Clear()

event to load my combo and everything works fine. 

But I need to clear some combos below as the selection, if altered in the to box, needs to be re-selected.

Sounds simple but from the above Items Requested I cannot find the other combos in the edit template.

Any suggestions...

Marcus

I am using 2 RadComboBoxes(ddlProductCategory and ddlProductCriterion) inside a RadGrid which is inside a RadPanelItem. The second combo box is filled manually when the user selects any option from the first combo box. The first one is bounded to a sqlDataSource; the second one is filled using a data reader. There is no problem inserting data and displaying it in the Rad Grid. However, I keep having errors when I try to Edit any existing record. I have read several forums and have tried to apply the logic but I still have the following error:

“Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerServerErrorException: Selection out of range. Parameter name: value”

I have tried already to use the ItemDataBound event to pre-populate the radComboBox:

if (e.Item.IsInEditMode)

{

GridEditableItem item = (GridEditableItem)e.Item;

if (!(e.Item is IGridInsertItem))

{

RadComboBox combo =(RadComboBox)item.FindControl("ddlProductCriterion");

RadComboBoxItem preselectedItem = new RadComboBoxItem();

preselectedItem.Text = item["Criterion"].Text;

preselectedItem.Value = item["ProductCriterionId"].Text;

combo.Items.Insert(0, preselectedItem);

combo.SelectedIndex = 0;

}

}

//These are my combo boxes

<telerik:GridTemplateColumn HeaderText="Product Category" UniqueName="TemplateColumnProductCategoryId" SortExpression="ProductCategoryId">

<ItemTemplate>

<asp:Label runat="server" ID="ProductCategoryId" Text='<%#  Eval("Category")%>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<br />

<telerik:RadComboBox ID="ddlProductCategory" runat="server" Skin="Web20" SelectedValue='<%# Bind("ProductCategoryId") %>' DataSourceID="dsProductCategoriesJanitorial" DataTextField="Category" DataValueField="Id" AutoPostBack="true" onselectedindexchanged="ddlProductCategory_SelectedIndexChanged1">

</telerik:RadComboBox>

</EditItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Product Criterion" UniqueName="TemplateColumnProductCriterionId" SortExpression="ProductCriterionId">

<ItemTemplate>

<asp:Label runat="server" ID="ProductCriterionId" Text='<%# Eval("Criterion")%>'> </asp:Label>&#160;

</ItemTemplate>

<EditItemTemplate>

<telerik:RadComboBox ID="ddlProductCriterion" runat="server" Skin="Web20"

SelectedValue='<%# Bind("ProductCriterionId") %>' ></telerik:RadComboBox>

</EditItemTemplate>

</telerik:GridTemplateColumn>

//This is my sqlDatasource located outside any objects (at the bottom of the page)

asp:SqlDataSource ID="dsJanitorialEq" runat="server" ConnectionString="<%$ ConnectionStrings:connLeed %>"

        DeleteCommand="DELETE FROM [JanitorialEquipment] WHERE [Id] = @Id" InsertCommand="INSERT INTO JanitorialEquipment(ProjectId, ProductName, PurchaseDate, CostPerItem, QuantityPurchased, ProductCategoryID, ProductCriterionId) VALUES (@ProjectId, @ProductName, @PurchaseDate, @CostPerItem, @QuantityPurchased, @ProductCategoryId, @ProductCriterionId)"

        SelectCommand="SELECT JanitorialEquipment.Id, JanitorialEquipment.ProjectId, JanitorialEquipment.ProductName, JanitorialEquipment.PurchaseDate, JanitorialEquipment.CostPerItem, JanitorialEquipment.QuantityPurchased, JanitorialEquipment.ProductCategoryID, JanitorialEquipment.ProductCriterionId, ProductCriterion.Criterion, ProductCategories.Category, ProductSections.Section FROM ProductSections RIGHT OUTER JOIN ProductCategories ON ProductSections.Id = ProductCategories.SectionId RIGHT OUTER JOIN JanitorialEquipment LEFT OUTER JOIN ProductCriterion ON JanitorialEquipment.ProductCriterionId = ProductCriterion.Id ON ProductCategories.Id = JanitorialEquipment.ProductCategoryID WHERE (JanitorialEquipment.ProjectId = @ProjectId)"

        UpdateCommand="UPDATE JanitorialEquipment SET ProductName = @ProductName, PurchaseDate = @PurchaseDate, CostPerItem = @CostPerItem, QuantityPurchased = @QuantityPurchased, ProductCategoryID = @ProductCategoryId, ProductCriterionId = @ProductCriterionId WHERE (Id = @Id)">

        <DeleteParameters>

            <asp:Parameter Name="Id" Type="Int32" />

        </DeleteParameters>

        <InsertParameters>

            <asp:QueryStringParameter Name="ProjectId" QueryStringField="projectid" />

            <asp:Parameter Name="ProductName" Type="String" />

            <asp:Parameter Name="PurchaseDate" Type="DateTime" />

            <asp:Parameter Name="CostPerItem" Type="Decimal" />

            <asp:Parameter Name="QuantityPurchased" Type="Int64" />

            <asp:Parameter Name="ProductCategoryId" Type="Int32" />

            <asp:Parameter Name="ProductCriterionId" Type="Int32" />

        </InsertParameters>

        <SelectParameters>

            <asp:QueryStringParameter Name="ProjectId" QueryStringField="projectid" />

        </SelectParameters>

        <UpdateParameters>

            <asp:Parameter Name="ProductName" Type="String" />

            <asp:Parameter Name="PurchaseDate" Type="DateTime" />

            <asp:Parameter Name="CostPerItem" Type="Decimal" />

            <asp:Parameter Name="QuantityPurchased" Type="Int64" />

            <asp:Parameter Name="ProductCategoryId" Type="Int32" />

            <asp:Parameter Name="ProductCriterionId" Type="Int32" />

            <asp:Parameter Name="Id" Type="Int32" />

        </UpdateParameters>

    </asp:SqlDataSource>

I have tried debugging this and have placed a break point inside the “If” statement above. The error comes before even reaching the breakpoint.
I have tried adding the code above in other events with no success. Do you recommend to use this code in other events? Any suggestions on how to solve this problem would be greatly appreciated. Thanks in advance!

I have tried everything in here and I still get the error.  What a frustrating effort this is. 

        If e.Item.IsInEditMode Then  ''''''' THIS IS ALWAYS FALSE SO THE CODE NEVER RUNS
            Dim item As GridEditableItem = DirectCast(e.Item, GridEditableItem)

            If Not (TypeOf e.Item Is IGridInsertItem) Then

                Dim combo As RadComboBox = DirectCast(item.FindControl("RadComboBox1"), RadComboBox)

                Dim preselectedItem As New RadComboBoxItem()
                preselectedItem.Text = item("Status").Text
                preselectedItem.Value = item("StatusID").Text
                combo.Items.Insert(0, preselectedItem)
                combo.SelectedIndex = 0
            End If

        End If
    End Sub

I have tried all your examples, i am using a Radlistview with a combobox inside. When the page load, i click on edit the combobox binds to my SQL data for Field City and displays it. Also I can go further and if i click on down arrow of combo box i produce i City Listing also from SQL data.

 My Issue is that after i select either the exsistng City or a new city from the dropdown list and click update, no errors but my selected City does not get updated.

I dont have any errors so i dont know where its failing.

Ok got it to work !

My issue was that i was not aware that the old textbox for City before trying to update to combobox was Visible False, it should have been deleted. Also the:

<asp:Label ID="CityLabel2" runat="server" AssociatedControlID="RadComboBox2" Text="City"></asp:Label>

AssociatedControlId needed to be rename to: RadComboBox2

Ok, now the only issue i see is and i dont know if this is able to be done please let me know.

If the user chooses to just enter test instead of selecting from the dropdown, and then clicks update i get this error.

Cannot insert the value NULL into column 'City', table 'FUNERALMANAGEMENTONLINE.dbo.Funeralhomes'; column does not allow nulls. UPDATE fails.
The statement has been terminated.

I know what the error means, why what is typed in as text is not being saved? Thank you

Ok whooooaa....got it !

This is my update, 

Protected Sub RadListView1_ItemUpdating(sender As Object, e As RadListViewCommandEventArgs)

        Dim editedItem As RadListViewEditableItem = DirectCast(e.ListViewItem, RadListViewEditableItem)
        Dim comboBox As RadComboBox = DirectCast(editedItem.FindControl("RadComboBox2"), RadComboBox)
        'SqlDataSource1.UpdateParameters.Add(New Parameter("City", DbType.String, comboBox.SelectedValue))
        SqlDataSource1.UpdateParameters.Add(New Parameter("City", DbType.String, comboBox.Text))
    End Sub

'SqlDataSource1.UpdateParameters.Add(New Parameter("City", DbType.String, comboBox.SelectedValue)) was only updating what was being binded from RadComboBox2_ItemsRequested !

Once i commented out such and added:

SqlDataSource1.UpdateParameters.Add(New Parameter("City", DbType.String, comboBox.Text))

Then i was able to get selected item from RadComboBox2_ItemsRequested and also INPUT TEXT Text to get updated.

I put this here so it can help anyone else . Thank you

this is kind of a kluge but it is what I ended up with - I added a hidden field to the row in the edit template with the radcombobox that is bound to the current value.  In the pre-render event I find the hidden field and set the radcombobox.text to its value.

Thanks, i thought about this trick, but i would like to find a better solution to have the possibility to bind also IsVisible or Enabled propreties. I know that i could use the same code for those properties but i try to use code behind the least possible.

Thanks

I am trying to achieve cascading dropdown scenario with the radcomboboxes in insertitemtemplate of Raddataform. Any guidance or suggestions are highly appreciable.

Thank you.