FILTER PROBLEM

GridKnownFunction.StartsWith;

how in 2008?

1. Open the form in design time
2. Select a RadGridView control
3. Locate in the property grid the MasterGridViewTemplate property and expand it
4. In the expanded properties under the MasterGridViewTemplate in the property grid, locate the Columns collection and open the collection editor for it
5. Locate the desired column in the collection editor
6. In the property grid on the left, locate the Filter property for the selected column and open the filter editor for it
7. Set the desired filter expression

Hello,

Am using filter option when the radgridview is being updated(adding rows one by one), but i could not able to use the filter box as it is getting disappered before entering the text. Because the grid is getting refreshed when adding rows. Also am doing scroll to last row. 

But then how to do filtering when doing the above operation.

Hello Visakh,

I would recommend using the new AutoFilterDelay or implement "Filter on Enter". This way you can perform the filtering operation after the user has finished typing: 

radGridView1.Columns[0].AutoFilterDelay = 3000;

I hope this helps. Please let me know if you have additional questions.

Regards,
Dimitar
Progress Telerik

Hi Dimitar

I have the below control setup in my code 

> It is a RadGridView

> I am updating the data dynamically in a constant rate 

> Also am scrolling to the end of the RadGridView when I add the data

> Now in between if I use the RadGridView filter built in, and if start to type somthing to search/ filter the text is getting disappeared

I want to avoid this 

Do you have a solution ?

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

Hi Dess,

Am using filter functionality. I have attached gif file to show the problem am facing. I could not able to type in anything to filter box, it is getting out of focus within a second. again i need to click there to type in, its annoying.

Thanks.

Hello, Visakh,    

        private void timer1_Tick(object sender, EventArgs e)
        {
            this.radGridView1.MasterTemplate.Refresh();
            Application.DoEvents();
            this.radGridView1.MasterView.TableFilteringRow.Cells[this.radGridView1.CurrentColumn.Name].BeginEdit();
        }

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

Hi Dess,

Thank you for the reply. Your reply helped to understand more better.

Am not doing any refresh using Refresh command. Can u look at the code and tell which line is making the grid to get refreshed.

I tried commenting out BeginUpdate, EndUpdate and also ScrollToRow. Whether adding the row to grid itself makes refresh operation internally?

 private void timer1_Tick(object sender, EventArgs e)
        {
            radGridView1.BeginUpdate();

            CurrentCount = messagesList.Count - previousCount;
            for (int i = previousCount; i < messagesList.Count; i++)
            {
                var msg = ((TraceMessage)messagesList[i]);
                if (msg == null) continue;
                if (radGridView1.Rows.Count == 501)
                {
                    radGridView1.Rows.RemoveAt(0);
                }
                if (_databaseParser != null)
                    radGridView1.Rows.Add(msg.Time, msg.CanId.ToString("X"), msg.MessageIndication, msg.Length, msg.DataString, _databaseParser.GetMessageById(msg.CanId) != null ? _databaseParser.GetMessageById(msg.CanId).Name : "");
                else
                    radGridView1.Rows.Add(msg.Time, msg.CanId.ToString("X"), msg.MessageIndication, msg.Length, msg.DataString);
            }

            previousCount = messagesList.Count;

            radGridView1.EndUpdate();

            if (radGridView1.Rows.Count > 0)
                radGridView1.TableElement.ScrollToRow(radGridView1.Rows.Last());

            //Application.DoEvents();
            //this.radGridView1.CurrentColumn.Name
            //this.radGridView1.MasterView.TableFilteringRow.Cells[1].BeginEdit();
        }

Thanks.

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

Hello all,

I am trying to utilize filters on a GridViewTextBoxColumn using C# in Visual Studio Professional 2015 and Telerik 2019.3.917.40, but I am not seeing the filters limit my data. I have tried this both in code and interactively in the UI.

Is there an event that I need to connect to get the UI to refresh with the filter applied?

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

Dess,

I am not seeing the grid data refresh when I enter data interactively or when I apply a FilterDescriptor.

I attached a screenshot of my UI after I entered a filter via the grid to show that the data is not filtering, along with a screenshot of the columns editor for the grid in question.

Below is also a code snippet of how I am trying to apply the filters via code.

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

Dess,

The main difference I see between your sample and my code is that I am setting the DataSource property of the RadGridView control to be a List<CustomClass> versus your DataTable.

As far as steps to replicate the problem, I have attached a short clip of me demonstrating the issue.

Below is the code for my custom class.

Hello, Jay,    

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