[Solved] Cannot fetch value from GridAutoCompleteColumn

[Anders]

In my radgrid I want to delete and store the deleted rows in a separate table.
I get an empty string as value where I use a GridAutoCompleteColumn.
The value I want is ItemNo.

<telerik:GridBoundColumn DataField="Whs" FilterControlAltText="Filter Whs column"
                    HeaderText="Whs" SortExpression="Whs" UniqueName="Whs">
                </telerik:GridBoundColumn>
                <telerik:GridAutoCompleteColumn DataTextField="ItemNo" DataValueField="ItemNo" DataField="ItemNo"
                    DataSourceID="sqlDS_mitmas" Filter="StartsWith" InputType="Text" HeaderText="ItemNo" UniqueName="ItemNo">
                </telerik:GridAutoCompleteColumn>

Protected Sub RadGrid1_ItemDeleted(sender As Object, e As Telerik.Web.UI.GridDeletedEventArgs) Handles RadGrid1.ItemDeleted

        Dim dataItem As GridDataItem = CType(e.Item, GridDataItem)

        Dim whs As String = dataItem("Whs").Text
        Dim itemno As String = dataItem("ItemNo").Text
        Dim itemname As String = dataItem("ItemName").Text
        Dim deletedby = User.Identity.Name.ToString()

        InsertHistory(whs, itemno, itemname, deletedby)

    End Sub

itemno is empty, how can i get it/fetch it?

[Kostadin]

Hi Anders,

When using an AutoCompleteColumn the text is displayed in a Literal controls which is added in the controls collection of the TadleCell. Since all controls are removed on ItemDelete event handler I am afraid you could not access the text on this event. Nevertheless you could hook OnDeleteCommand event handler and access the Literal text there. Please check out the following code snippet.

Protected Sub RadGrid1_DeleteCommand(sender As Object, e As GridCommandEventArgs)
    Dim item As GridDataItem = TryCast(e.Item, GridDataItem)
    Dim itemno As String = TryCast(item("ItemNo").Controls(0), Literal).Text
End Sub

Regards,
Kostadin
Telerik