Immediate Filtering Problem

4 posts, 1 answers
  1. Daniel
    Daniel avatar
    159 posts
    Member since:
    Feb 2014

    Posted 23 Oct 2014 Link to this post

    Hello,

    I am working on a project with RadGrid.
    I'm trying to implement a filter like the following example:
    Filtering with Client-Side Binding

    I want the Grid values to change according to the text which the user is typing in the filter Textbox.
    In my Project I use a DataTable as a data source.

    How can I do this?

    My code:
    01.Public Class Grid_Filter_Client
    02.    Inherits System.Web.UI.Page
    03.    Dim dd As New DummyData
    04.    Dim dt As New DataTable
    05.    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
    06. 
    07.        If Not IsPostBack Then
    08. 
    09.            SetGridProp(RadGrid1, True)
    10.        Else
    11. 
    12.        End If
    13. 
    14. 
    15.    End Sub
    16. 
    17.    Private Sub SetGridProp(ByRef grd, ByVal auto)
    18.        dt = dd.GenTableData2
    19.        grd.AllowFilteringByColumn = True
    20.        grd.FilterType = GridFilterType.CheckList
    21.        grd.MasterTableView.PagerStyle.AlwaysVisible = True
    22.        grd.AllowSorting = True
    23. 
    24.        ''''''''''''''''''
    25.        'grd.MasterTableView.CheckListWebServicePath = "dt"
    26. 
    27.        If auto Then
    28.            grd.MasterTableView.AutoGenerateColumns = False
    29. 
    30.            grd.MasterTableView.DataKeyNames = {dt.Columns(0).ColumnName}
    31.            grd.MasterTableView.ClientDataKeyNames = {dt.Columns(0).ColumnName}
    32. 
    33.            Dim GridBoundCol As GridBoundColumn
    34.            For index = 0 To dt.Columns.Count - 1
    35.                GridBoundCol = New GridBoundColumn
    36.                GridBoundCol.FilterDelay = 200
    37.                GridBoundCol.FilterCheckListWebServiceMethod = dt.Columns(index).ColumnName
    38.                GridBoundCol.DataField = dt.Columns(index).ColumnName
    39.                GridBoundCol.HeaderText = dt.Columns(index).ColumnName
    40.                grd.MasterTableView.Columns.Add(GridBoundCol)
    41. 
    42.            Next
    43. 
    44. 
    45.            grd.DataSource = dt
    46. 
    47.            ''''''''''''''''''''
    48.            'grd.ClientSettings.DataBinding.SelectMethod = ""
    49.            'grd.ClientSettings.DataBinding.Location = ""
    50.            grd.ClientSettings.DataBinding.SortParameterType = GridClientDataBindingParameterType.Linq
    51.            grd.ClientSettings.DataBinding.FilterParameterType = GridClientDataBindingParameterType.Linq
    52.        End If
    53.    End Sub
    54.   
    55. 
    56.    Private Sub RadGrid1_NeedDataSource(sender As Object, e As GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource
    57.        dt = dd.GenTableData2
    58.        RadGrid1.DataSource = dt
    59.    End Sub
    60. 
    61.     
    62.    
    63.End Class

    Currently when I try to filter, the grid’s data doesn’t changed.

    Another problem that I have is that sometimes when I delete the whole text from the filter textbox, all cells’ values are replaced with “System.Data.DataRowView”

    P.S.  I've included a video that shows the problems I have.
    http://youtu.be/0-FSvR5t-wQ

     Thanks,
    Daniel
  2. Answer
    Eyup
    Admin
    Eyup avatar
    3225 posts

    Posted 28 Oct 2014 Link to this post

    Hi Daniel,

    I'm sending a sample RadGrid web site to demonstrate how you can achieve the requested functionality. Please run the attached application and let me know if it helps you.

    In case you do not use paging, you can also check the following code-library:
    http://www.telerik.com/support/code-library/quick-search---filtering-rows-depending-on-entered-text-instantly-when-paging-is-disabled

    Regards,
    Eyup
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  3. Daniel
    Daniel avatar
    159 posts
    Member since:
    Feb 2014

    Posted 30 Oct 2014 in reply to Eyup Link to this post

    Hi Eyup,

    Thanks so much for all the code you’ve provided!! It works fine!

    I wanted to ask if I can add a text filter option to the project you’ve sent, as appears here:
    http://designshack.net/tutorialexamples/html5-autocomplete-suggestions/
    When the user enters a Character in TextBox, it is highlighted in the drop-down.

    Thank you,
    Daniel.
  4. Eyup
    Admin
    Eyup avatar
    3225 posts

    Posted 04 Nov 2014 Link to this post

    Hello Daniel,

    To achieve this requirement, you can use RadComboBox:
    http://demos.telerik.com/aspnet-ajax/combobox/examples/overview/defaultcs.aspx

    In combination with FilterTemplates:
    http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/filtering/filter-templates/defaultcs.aspx

    Hope this helps.

    Regards,
    Eyup
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
Back to Top