RadGrid with Bound and TemplateColumns not updating

[Amar]

Hi,

I have a problem when updating RadGrid that contains Bound columns, ItemTemplate and EditItemTemplate columns. Whenever I click update button on a row, the update does not work and no error message I get. Below I provided my code. Please help.

<telerik:RadGrid ID="RadGrid1" runat="server"  OnItemDataBound="OnItemDataBoundHandler"

     AllowPaging="True" 

 

………..

 

    <Columns>

     <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn">

 

                    <ItemStyle CssClass="MyImageButton"></ItemStyle>

 

                </telerik:GridEditCommandColumn>

 

        <telerik:GridBoundColumn DataField="idCol" DataType="System.Int64"

            FilterControlAltText="Filter idCol column" HeaderText="idCol" ReadOnly="True"

            SortExpression="idCol" UniqueName="idCol">

        </telerik:GridBoundColumn>

 

        <telerik:GridBoundColumn DataField="bondNo"

            FilterControlAltText="Filter bondNo column" HeaderText="bondNo"

            SortExpression="bondNo" UniqueName="bondNo" EditFormColumnIndex="0">

        </telerik:GridBoundColumn>

 

         <telerik:GridTemplateColumn HeaderText="OrderNo" ItemStyle-Width="240px">

                    <ItemTemplate>

                        <%#DataBinder.Eval(Container.DataItem, "OrderNo")%>

                    </ItemTemplate>

                    <EditItemTemplate>

                        <telerik:RadComboBox runat="server" ID="RadComboBox1" DataTextField="OrderNo"

                            DataValueField="OrderNo" AutoPostBack="true" OnSelectedIndexChanged="OnSelectedIndexChangedHandler" >

                          

                        </telerik:RadComboBox>

                    </EditItemTemplate>

                </telerik:GridTemplateColumn>

                <telerik:GridTemplateColumn HeaderText="OrderItem" ItemStyle-Width="240px">

                    <ItemTemplate>

                        <%#DataBinder.Eval(Container.DataItem, "OrderItem")%>

                    </ItemTemplate>

                    <EditItemTemplate>

                        <telerik:RadComboBox runat="server" ID="RadComboBox2" DataTextField="OrderItem" DataValueField="ItemNo">

                        

                       </telerik:RadComboBox>

                    </EditItemTemplate>

                </telerik:GridTemplateColumn>

 

    </Columns>

Protected Sub OnItemDataBoundHandler(sender As Object, e As GridItemEventArgs) Handles RadGrid1.ItemDataBound

    If e.Item.IsInEditMode Then
        Dim editItem As GridEditFormItem = CType(e.Item, GridEditFormItem)

        Dim id3 As String = editItem.GetDataKeyValue("IdCol").ToString()
        Dim ds As New DataSet
        ds = GetOrderNo(id3)
        Dim ordNo, itemNo As String
        ordNo = ds.Tables(0).Rows(0)(0)
        itemNo = ds.Tables(0).Rows(0)(1).ToString().Trim()

        Dim OrderCombo As RadComboBox = TryCast(e.Item.FindControl("RadComboBox1"), RadComboBox)
        OrderCombo.DataSource = GetDataTable("SELECT OrderNo FROM Orders")
        OrderCombo.DataBind()
        OrderCombo.SelectedValue = ordNo

        Dim ItemCombo As RadComboBox = TryCast(editItem.FindControl("RadComboBox2"), RadComboBox)
        ItemCombo.DataSource = GetDataTable("SELECT ItemNo,ItemNo as OrderItem FROM Order_Items where OrderNo='" & ordNo & "'")
        ItemCombo.DataBind()
        ItemCombo.SelectedValue = itemNo

    End If

End Sub

[Shinu]

Hi,

I am not sure about your requirement. If you want to update the value in DataBase, please put your code for updating db inside UpdateCommand event, which fires when you click the update button. But I guess you want to set selected value of the RadComboBox in edit mode after inspecting from your code, which worked as expected at my end. Please elaborate your scenario so that I can help you.

Thanks,
Shinu.

[Amar]

Hi Shinu,
I put my code for updating database inside UpdateCommand event as suggested and it works now.
Thank you a lot for your help.