Filter string on template column bound by int

[Arsalan Ansari]

i have a RadGrid with some template columns that are bound by a SQL relationship ID that i want to filter by the Name instead.

For example, my orders table is connected to the drivers table via the DriverID.  On the EditItemTemplate, i have a rad combo box that is linked to the list of drivers and the selectedvalue inserts the DriverID in the RadGrid but for the ItemTemplate, it is simply a label that displays the DriverName

However, Filtering only allows me to filter by DriverID, i want to be able to Filter by DriverName

How can i do this?

<telerik:GridTemplateColumn HeaderText="Driver" DataField="DriverID" SortExpression="Driver">
                    <ItemTemplate>
                        <asp:Label runat="server" ID="lblDriver" Text='<%# Eval("DriverName") %>'></asp:Label>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <telerik:RadComboBox ID="rcbDrivers" runat="server"
                                                             DataSourceID="sdsSelectDriversForRCB"
                                                             DataTextField="DriverName" SelectedValue='<%# Bind("DriverID") %>'
                                                             DataValueField="DriverID">
                        </telerik:RadComboBox>
                    </EditItemTemplate>
                </telerik:GridTemplateColumn>

[Tsvetoslav]

Hello Arsalan,

Attached is a small sample demonstrating how to achieve your requirement.

Hope it helps.

Greetings,
Tsvetoslav
the Telerik team