1. Home
  2. Forum
  3. WinForms
  4. [Solved] - filter problem?

[Solved] - filter problem?

Hi,
I have a big problems when using the searchbox with datagrid (search combine allowfilter):

- datagrid does not recognize the following strings: "đ", "ấ", zắng, ..(The textchange event seems to forget the final result)

more specifically: suppose I am typing "khang", if I continue to type the letter "a", in English it will normally be "khanga", but for some languages it will be "khâng"(immedialtely)
if I use textchange_event, It will show through many steps: khang -> khanga -> khang -> khan -> kha -> khâ -> khân -> khâng (I want the textbox to only work after the final result and not work with intermediate changes)
It work pretty well if allowfilter = false, but if allowfilter = true, I get the following result:

Edit: It seems that the problem with textboxext, if I copy textbox values to excel, they are completely different
How do I convert textbox.text to their true values?



8 Replies
VS Vijayarasan Sivanandham Syncfusion Team May 19, 2020 03:45 AM UTC

Hi Khanh Dang,

Thank you for contacting Syncfusion support.

Currently, we are analyzing your requirement of “Filter Problem” in SfDataGrid. We will update you the details on or before May 20, 2020.

We appreciate your patience until then.

Regards,
Vijayarasan S 


TG The GridLock May 19, 2020 07:04 AM UTC

Hi,
I think it's because I use the wrong font when typing data in Excel, it's different from the font in the textbox so even though they display exactly the same, but the number of characters is different.
Can I avoid this?
My file test:

VS Vijayarasan Sivanandham Syncfusion Team May 21, 2020 03:42 AM UTC

Hi Khanh Dang, 
Sorry for the inconvenience caused. 
We are currently working on this and we need two more business days to validate this. We will update you with further details on May 22, 2020. 
We appreciate your patience until then.  
Regards, 
Vijayarasan S 


VS Vijayarasan Sivanandham Syncfusion Team May 24, 2020 09:59 AM UTC

Hi Khanh Dang,


Thank you for your patience.


Can you please provide the more information related to your query. 
It will be helpful for us to check on it and provide you the solution at the earliest.

Regards,
Vijayarasan S



TG The GridLock May 26, 2020 04:42 AM UTC

Hi Vijayarasan,
I don't know much about it but I've heard a lot about it, 
ex: using the same font but using different charsets (unicode, telex,.) then when typing, the text will be different. ie I will have to find the appropriate charset for them and convert them to the charset suitable for textbox, then when I type them in the textbox, the datagrid will display filterset. is that so?

SS Susmitha Sundar Syncfusion Team May 28, 2020 03:00 AM UTC

Hi Khanh Dang, 
 
Thank you for the update. 
 
We suspect that when you enter the different charset, you should press the same key for more than one time. But search function call for every text changing. You can resolve this by call the Search method after entering all the text in textbox. Please refer the below code snippet, 
 
txtDisplayRecord.KeyDown += TxtDisplayRecord_KeyDown; 
 
private void TxtDisplayRecord_KeyDown(object sender, KeyEventArgs e) 
{ 
    if (e.KeyCode == Keys.Enter) 
    { 
        sfDataGrid.SearchController.AllowFiltering = true; 
        sfDataGrid.SearchController.Search(txtDisplayRecord.Text); 
        e.SuppressKeyPress = true; 
    } 
} 
 
Here, we have performed the search action after press the Enter key only. We hope it will helps you. 
 
 
Please check the sample and let us know if you need further assistance on this. 
 
Regards, 
Susmitha S 


TG The GridLock May 28, 2020 05:48 AM UTC

Hi Susmitha,
There is also a solution. I will temporarily use your code.

SS Susmitha Sundar Syncfusion Team May 29, 2020 06:52 AM UTC

Hi khanh dang, 
 
Please let us know if you have any further queries on this. We are happy to help you. 
 
Regards, 
Susmitha S 


Loader.
Up arrow icon