[Solved] Filtering issue in the grid

[anna]

I have grid that I bind with a datatable in my code behind file. I have Allowfiltering set true for my first column. but it does not work. It doesn't filter my data in the grid. Need Help...

<telerik:RadGrid ID="RadGrid1" AutoGenerateColumns="False" OnItemDataBound="RadGrid1_ItemDataBound" runat="server" AllowSorting="True"

GridLines="None" Width="560px" AllowPaging="True" PageSize="12" AllowFilteringByColumn="True">

<MasterTableView

GridLines="Horizontal">

<RowIndicatorColumn Visible="False">

<HeaderStyle Width="20px" />

</RowIndicatorColumn>

<ExpandCollapseColumn Resizable="False" Visible="False">

<HeaderStyle Width="20px" />

</ExpandCollapseColumn>

<Columns>

<telerik:GridTemplateColumn DataField="Order" SortExpression="Order" HeaderText="Order #" UniqueName="column1">

<ItemTemplate>

<asp:HyperLink runat="server" ID="orderLnk"

Text='<%# DataBinder.Eval(Container, "DataItem.Order") %>'></asp:HyperLink>

</ItemTemplate>

<ItemStyle Font-Underline="True" Font-Bold="True" />

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn AllowSorting="False" DataField="ProdNum" HeaderText="Pro #"

UniqueName="gcolumn2" AllowFiltering="False" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn AllowSorting="False" DataField="ShipName" HeaderText="Ship Name"

UniqueName="gcolumn3" AllowFiltering="False" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn AllowSorting="False" DataField="City" HeaderText="City"

UniqueName="gcolumn41" AllowFiltering="False" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn AllowSorting="False" DataField="State" HeaderText="State"

UniqueName="gcolumn4" AllowFiltering="False" >

</telerik:GridBoundColumn>

</Columns>

<EditFormSettings>

<PopUpSettings ScrollBars="None"/>

</EditFormSettings>

<AlternatingItemStyle BackColor="#99FF99" Font-Bold="False" Font-Italic="False" Font-Overline="False"

Font-Strikeout="False" Font-Underline="False" Wrap="True" />

<HeaderStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"

Font-Underline="False" Wrap="True" />

</MasterTableView>

</telerik:RadGrid>

[Princy]

Hi Anna,

Check out the following help document link.
Implementing filtering for template/custom columns

Thanks
Princy.

[anna]

In my case filtering is not working at all. I tried the same method as mentioned in tutorial. please take a look:

<telerik:RadGrid ID="RadGrid1" AutoGenerateColumns="False" OnItemDataBound="RadGrid1_ItemDataBound" runat="server" AllowSorting="True"

GridLines="None" Width="560px" AllowPaging="True" PageSize="12" AllowFilteringByColumn="True" Skin="WebBlue">

<MasterTableView AllowFilteringByColumn="true"

GridLines="Horizontal">

<RowIndicatorColumn Visible="False">

<HeaderStyle Width="20px" />

</RowIndicatorColumn>

<ExpandCollapseColumn Resizable="False" Visible="False">

<HeaderStyle Width="20px" />

</ExpandCollapseColumn>

<Columns>

<telerik:GridTemplateColumn DataField="Order" SortExpression="Order" HeaderText="Order #" UniqueName="column1">

<ItemTemplate>

<asp:HyperLink runat="server" ID="orderLnk"

Text='<%# Eval("Order") %>'></asp:HyperLink>

</ItemTemplate>

<ItemStyle Font-Underline="True" Font-Bold="True" />

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn AllowSorting="False" DataField="ProdNum" HeaderText="Pro #"

UniqueName="gcolumn2" AllowFiltering="False" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn AllowSorting="False" DataField="ShipName" HeaderText="Ship Name"

UniqueName="gcolumn3" AllowFiltering="False" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn AllowSorting="False" DataField="City" HeaderText="City"

UniqueName="gcolumn41" AllowFiltering="False" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn AllowSorting="False" DataField="State" HeaderText="State"

UniqueName="gcolumn4" AllowFiltering="False" >

</telerik:GridBoundColumn>

</Columns>

<EditFormSettings>

<PopUpSettings ScrollBars="None"/>

</EditFormSettings>

<AlternatingItemStyle BackColor="#99CCFF" Font-Bold="False" Font-Italic="False" Font-Overline="False"

Font-Strikeout="False" Font-Underline="False" Wrap="True" />

<HeaderStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"

Font-Underline="False" Wrap="True" Font-Size="Small" ForeColor="Black" />

<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Size="Small"

Font-Strikeout="False" Font-Underline="False" ForeColor="Black" Wrap="True" />

</MasterTableView>

<ClientSettings AllowColumnsReorder="True" ReorderColumnsOnClient="True">

</ClientSettings>

</telerik:RadGrid>

code:

Sub

RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As GridItemEventArgs) Handles RadGrid1.ItemDataBound

If TypeOf e.Item Is GridDataItem Then

Dim item As GridDataItem = DirectCast(e.Item, GridDataItem)

Dim CategoryIDLabel2 As HyperLink = DirectCast(item("column1").FindControl("orderLnk"), HyperLink)

CategoryIDLabel2.NavigateUrl =

"orderDetails.aspx?id=" & CategoryIDLabel2.Text

End If

End Sub

[Shinu]

Hi Anna,

I tried this on my end and it is working correctly. Have you set the correct DataField? My code is as follows.

CS:

protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
    {
        if (e.Item is GridDataItem)
        {
            GridDataItem item = (GridDataItem)e.Item;
            HyperLink hyplnk = (HyperLink)item["ProductName"].FindControl("HyperLink1");
            hyplnk.NavigateUrl = "http://www.google.co.in/";
        }
    }

ASPX:

 <telerik:RadGrid ID="RadGrid1"  AllowFilteringByColumn="true"   runat="server"   OnItemDataBound="RadGrid1_ItemDataBound" >


                <MasterTableView>
                    <Columns>
                        <telerik:GridTemplateColumn UniqueName="ProductName" DataField="ProductName"  HeaderText="ProductName"  >
                          <ItemTemplate>
                              <asp:HyperLink ID="HyperLink1"  Text='<%#Eval("ProductName") %>' runat="server" ></asp:HyperLink>
                          </ItemTemplate>
                        </telerik:GridTemplateColumn>

                    </Columns>

                </MasterTableView>
            </telerik:RadGrid>

Thanks
Shinu.