RadGridView - Filter Programatically

Hello 

May I Have Just "Contains" for Filtering Without displaying filter box (Followed By this link)

https://docs.telerik.com/devtools/winforms/controls/gridview/filtering/basic-filtering

I`d like to Reduce the Filter Menu Options or Not showing filter box at all.

when ever End User start to Type text ,Displaying Search Text Box and then search with operator "Contains" for every Column.

thank you

Hello again

Excuse me Can I Have ServerSide Filtering and sorting in radgridview in winform. Do You Have a sample?

Thank You

Hello, Aseman,     

The "Contains" filter operator is relevant for the text columns. For the other column types different filter operators are displayed. 

The following KB article demonstrates how to specify default filter operator and thus you can set the "Contains" filter operator for the text columns: https://docs.telerik.com/devtools/winforms/knowledge-base/set-default-filter-operators-in-gridview 

The RadGridView.ContextMenuOpening event is fired when the filter popup is going to be opened. This is the appropriate place to hide some of the menu items that you don't want to be displayed: 

        public RadForm1()
        {
            InitializeComponent();

            this.radGridView1.EnableFiltering = true;
            this.radGridView1.ContextMenuOpening+=radGridView1_ContextMenuOpening;
        }

        private void radGridView1_ContextMenuOpening(object sender, ContextMenuOpeningEventArgs e)
        {
            if (e.ContextMenuProvider is GridFilterCellElement)
            {
                e.ContextMenu.Items[0].Visibility = ElementVisibility.Collapsed;
            }
        }

If the applied default filter operator is the only one that you are going to use and want to hide the filter button, ou can subscribe to the ViewCellFormatting event and use the following code snippet:  

        private void radGridView1_ViewCellFormatting(object sender, CellFormattingEventArgs e)
        {
            GridFilterCellElement filterCell = e.CellElement as GridFilterCellElement;
            if (filterCell!=null)
            {
                filterCell.FilterButton.Visibility = ElementVisibility.Collapsed;
            }
        }

Note that all operations like filtering, paging, grouping etc. that RadGridView offers, are client-side based since RadGridView is designed to work with its data applied via the DataSource property. Server-side filtering may be implemented with RadVirtualGrid as it loads data on demand. You can refer the Demo application >> VirtualGrid >> First look example where in the FilterChanged event the new relevant data is extracted from the external data source and then filled in the virtual grid via the CellValueNeeded event.

I hope this information helps.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

thank you Dear Dess

and how can I change the Size of context Menu? Because I have just One Record "Contains" in it.

Hello Aseman,

Dess is out of the office today so I will be handling this case. 

You can set the size of the context menu for the filter pop up in the ContextMenuOpening event:

private void radGridView1_ContextMenuOpening(object sender, ContextMenuOpeningEventArgs e)
{
    if (e.ContextMenuProvider is GridFilterCellElement)
    {
        e.ContextMenu.MinimumSize = new Size(100, 0);
    }
}

I hope this helps. Should you have any other questions do not hesitate to ask.

Regards,
Nadya
Progress Telerik