[Sv] - Advance search question?

Question

Hi,I am looking for an advanced search function (not applicable for each column) for the following cases or can I create the following functions?-search empty row or not empty row-search all rows contains at least one empty cell(search combine wildcard or RegEx pattern)thanks you!

Vijayarasan Sivanandham · Answer

Hi Khanh Dang,Thank you for contacting Syncfusion support. Currently, SfDataGrid does not have a support for Advance Search. We are checking the feasibility to achieve your requirement and we will update you the details on May 13, 2020.Regards,Vijayarasan S

Vijayarasan Sivanandham · Answer

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 15, 2020. 
We appreciate your patience until then.  
Regards, 
Vijayarasan S

Susmitha Sundar · Answer

Hi khanh dang, 
 
Sorry for the inconvenience caused.   
 
We are provided the searching for column wise only. We have achieved your requirement for empty column. Now, we are working for the requirement “Search for empty rows”. We will provide the update on May 19, 2020. 
 
We appreciate your patience until then.   
   
Regards,   
Susmitha S

Susmitha Sundar · Answer

Hi khanh dang, 
 
Thank you for your patience. 
 
We have achieved your requirement by overriding the SfDataGrid.SearchController and modify the SearchController.FilterRecords method.  
 




public class SearchControllerExt : SearchController 
{ 
    SearchPanel searchPanel; 
    public SearchControllerExt(SfDataGrid grid, SearchPanel panel) : 
    base(grid) 
    { 
        searchPanel = panel; 
        this.AllowHighlightSearchText = false; 
    } 
 
    protected override bool FilterRecords(object dataRow) 
    { 
        if (this.Provider == null) 
            Provider = this.DataGrid.View.GetPropertyAccessProvider(); 
        if (searchPanel.chkEmptyRows.Checked) 
        { 
            for (int i = 0; i < this.DataGrid.Columns.Count; i++) 
            { 
                var col = this.DataGrid.Columns[i]; 
                var cellvalue = Provider.GetFormattedValue(dataRow, col.MappingName); 
                if (cellvalue == null) 
                    continue; 
                else 
                    return false; 
            } 
            return true; 
        } 
        else if (searchPanel.chkNonEmpty.Checked) 
        { 
            for (int i = 0; i < this.DataGrid.Columns.Count; i++) 
            { 
                var col = this.DataGrid.Columns[i]; 
                var cellvalue = Provider.GetFormattedValue(dataRow, col.MappingName); 
                if (cellvalue != null) 
                    continue; 
                else 
                    return false; 
            } 
            return true; 
        } 
        else if(searchPanel.chkEmptyCell.Checked) 
        { 
 
            for (int i = 0; i < this.DataGrid.Columns.Count; i++) 
            { 
                var col = this.DataGrid.Columns[i]; 
                var cellvalue = Provider.GetFormattedValue(dataRow, col.MappingName); 
                if (cellvalue == null) 
                    return true; 
                else 
                    continue; 
            } 
            return false; 
        } 
        else 
            return base.FilterRecords(dataRow); 
    } 
    
} 
 
Sample link: https://www.syncfusion.com/downloads/support/forum/154103/ze/Searching-1490618677 
 
Video link: https://www.syncfusion.com/downloads/support/forum/154103/ze/emptyRowEmptyCellSearching-270590222 
 
Please check the sample and let us know if you need further assistance on this. 
 
Regards, 
Susmitha S

The GridLock · Answer

Thanks Susmitha,  I will try your code soon

Vijayarasan Sivanandham · Answer

Hi Khanh Dang,Thanks for the update. 
 
We will wait to hear from you. 
 
Regards, 
Vijayarasan S

The GridLock · Answer

Hi ,I like this approach. Thanks for the support!

Vijayarasan Sivanandham · Answer

Hi Khanh Dang, 
 
Thanks for the update. 
 
We are glad to know that the reported problem has been resolved at your end. Please let us know if you have any further queries on this. We are happy to help you😊. 
 
Regards, 
Vijayarasan S

The GridLock · Answer

Hi Vijayarasan,Do I need to reset the searchcontroller when I no longer use this extension function? How do I give it up?

Susmitha Sundar · Answer

Hi khanh dang, 
 
You can achieve the default searching by this same SearchController. In this sample, I have added the text box to search the text, 
 




private void btnSearch_Click(object sender, EventArgs e) 
{ 
    if(textBox1.Text== string.Empty) 
    { 
        sfDataGrid.SearchController.Search(" "); 
    } 
    else 
    { 
        sfDataGrid.SearchController.Search(textBox1.Text); 
    } 
     
} 
 
  
 
Sample link: https://www.syncfusion.com/downloads/support/forum/154103/ze/SearchingEmptyDefault95293842 
 
Please let us know if you need further assistance on this. 
 
Regards, 
Susmitha S

The GridLock · Answer

Hi Vijayarasan, I mean destroy the class assignment to the searchcontroller.

Susmitha Sundar · Answer

Hi khanh dang, 
 
Thank you for the update. 
 
If you don’t want that customized searching behavior, you need to manually remove the SearchController assigning code. 
 




public Form1() 
 { 
     InitializeComponent(); 
     orderInfo = new OrderInfoCollection(); 
     this.sfDataGrid1.DataSource = orderInfo.OrdersListDetails; 
     panel = new SearchPanel(this.sfDataGrid1); 
     sfDataGrid1.Controls.Add(panel); 
     panel.BringToFront(); 
     panel.Anchor = AnchorStyles.Right | AnchorStyles.Bottom; 
     panel.Location = sfDataGrid1.TableControl.PointToClient(new Point(sfDataGrid1.Width - (panel.Width) - 8, 363)); 
     panel.Show(); 
   
     sfDataGrid1.TableControl.KeyDown += TableControl_KeyDown; 
     this.sfDataGrid1.SearchController.AllowHighlightSearchText = false; 
     sfDataGrid1.SearchController = new SearchControllerExt(sfDataGrid1, panel); 
 } 
 
Please let us know if you need further assistance on this. 
 
Regards, 
Susmitha S

The GridLock · Answer

Hi susmitha,Thanks for sample code, I got it.

Susmitha Sundar · Answer

Hi khanh dang, 
 
Thanks for the update. 
 
We are glad to know that the reported problem has been resolved at your end. Please let us know if you have any further queries on this.  
 
Regards, 
Susmitha S

The GridLock · Answer

Hi Susmitha,I have a datagrid, after using the filter function, I want to continue using advance search, can I continue to search based on this filter view? I tried but it searched the entire view, including the filter results. can i use this but search all column?

Susmitha Sundar · Answer

Hi khanh dang, 
 
Thank you for the update. 
 
In SfDataGrid, searching performed on only filtered records. Please refer the below sample. In this sample, we have the records only 10. And it has country name Germany for two rows. I have filtered the one of the rows. When I search Germany, it will show only one match.  
 
Sample link: https://www.syncfusion.com/downloads/support/forum/154103/ze/DataGrid_WF-1422322252 
 
Please check the sample and let us know if you need further assistance on this. 
 
Regards, 
Susmitha S

The GridLock · Answer

Hi susmitha,agree, searching performed on only filtered records, The steps I have taken are:step1: run your codeStep2: Filter "Germany" in Column CountryStep3: Search "Martin"This is what I expected, but the problem I realized is that 'search method' checks all rows in the database [10 rows] containing "Martin" and then matches the rows shown in the filter to get final result. (I used the search override and when I debug, it checked all the rows.)I want it to be faster (check only filtered rows [3 rows] then search for "Martin" on these 3 rows) to get final result.

Vijayarasan Sivanandham · Answer

Hi Khanh Dang,Thanks for the update. 
Currently, we are analyzing your requirement of “Advance Search performance on SfDataGrid”. We will validate and update you the details on June 26, 2020. 
 
We appreciate your patience until then. 
 
Regards, Vijayarasan S

The GridLock · Answer

Hi Vijayarasan,New question: I can change cell values by 2 ways: using setvalue and manual edit.Please show me how to cancel value_change if it has a value other than "Abc" for both ways.

Vijayarasan Sivanandham · Answer

Hi Khanh Dang ,Thanks for the update.Please find answer for your queries below 




Queries 

Solutions 


 the problem I realized is that 'search method' checks all rows in the database [10 rows] containing "Martin" and then matches the rows shown in the filter to get final result 

Currently, we are analyzing your requirement of “Advance Search performance on SfDataGrid”. We will validate and update you the details on June 30, 2020.  


 
I can change cell values by 2 ways: using setvalue and manual edit. 
Please show me how to cancel value_change if it has a value other than "Abc" for both ways. 
 

Manual Edit:Your requirement can be achieved by using SfDataGrid.CurrentCellValidating event. Please refer the below code snippet, 




sfDataGrid.CurrentCellValidating += SfDataGrid_CurrentCellValidating;private void SfDataGrid_CurrentCellValidating(object sender, Syncfusion.WinForms.DataGrid.Events.CurrentCellValidatingEventArgs e) 
{ 
            if (e.NewValue.ToString() != "Abc") 
                e.NewValue = e.OldValue;             
} 
SetValue: In this case you need to set the condition before the Set value. Because we set value in programmatic to add the value in SfDataGrid. If we misunderstood your requirement, please provide more information regarding the requirement. This would help us to proceed further. 
Sample Link: https://www.syncfusion.com/downloads/support/directtrac/154103/ze/AddNewRow14227430 Regards,Vijayarasan S

The GridLock · Answer

Hi Vijayarasan,Thanks for the clear explanation.If i want to delete this record ! can i do this?sfDataGrid.CurrentCellValidating += SfDataGrid_CurrentCellValidating;private void SfDataGrid_CurrentCellValidating(object sender, Syncfusion.WinForms.DataGrid.Events.CurrentCellValidatingEventArgs e) { if !(conditional1)    e.newvalue=e.oldvalue;         if !(conditional2)             sfDataGrid.deleteselectedrecord();         }

Vijayarasan Sivanandham · Answer

Hi Khanh Dang,Thanks for the update.In SfDataGrid CurrentCellValidating event fires on Editing in SfDataGrid. So, the selected record could not be deleted when editing in progress. The current cell will not end the editing until the CurrentCell validation is progress.  Your requirement Can be achieved by using SfDataGrid.CurrentCellEndEdit event in SfDataGrid. Please refer the Below code snippet, 




this.sfDataGrid1.CurrentCellEndEdit += SfDataGrid1_CurrentCellEndEdit;private void SfDataGrid1_CurrentCellEndEdit(object sender, Syncfusion.WinForms.DataGrid.Events.CurrentCellEndEditEventArgs e) 
{ 
            if !(conditional2) 
             sfDataGrid1.DeleteSelectedRecords(); 
} 
Regards,Vijayarasan S

The GridLock · Answer

ok Vijayarasan , i got it.

Vijayarasan Sivanandham · Answer

Hi Khanh Dang,Thanks for the update.Your requirement can be achieved by customization SearchController.FilterReocrds method to search the match text for view records in SfDataGrid. Please refer the below code snippet, 




public class SearchControllerExt : SearchController 
{ 
        SfDataGrid dataGrid; 
        public SearchControllerExt(SfDataGrid grid) : 
        base(grid) 
        { 
            dataGrid = grid; 
        } 
        protected override bool FilterRecords(object dataRow) 
        { 
            if (dataGrid.View.Records.Any(x => (x.Data as OrderInfo).OrderID.ToString().Equals((dataRow as OrderInfo).OrderID.ToString()))) 
                return base.FilterRecords(dataRow); 
            else return false; 
        } 
        protected override bool MatchSearchText(GridColumn column, object record) 
        {             
              return base.MatchSearchText(column, record); 
        } 
} 
 
Sample Link: https://www.syncfusion.com/downloads/support/forum/154103/ze/Sample177777049 
Regards,Vijayarasan S

The GridLock · Answer

Hi Vijayarasan ,After filtering, I have these 3 lines, I want if I continue to search, the code will only check these 3 lines (ID: 7,8,9)I checked your code, they keep checking from the beginning all the rows.

Vijayarasan Sivanandham · Answer

Hi Khanh Dang,Thanks for the update. Can you please confirm, In your sample Filtering enable for SfDataGrid and applied UI Filter then Search the text with enabled Searchcontroller.AllowFiltering?Regards,Vijayarasan S

The GridLock · Answer

Hi Vijayarasan ,please see myvideo

Vijayarasan Sivanandham · Answer

Hi Khanh Dang,Thanks for the update. 
In SfDataGrid normally filters apply for all records because we are using view filter for Searching in SfDataGrid. So, you could improve the performance by enabling UsePLINQ property in SfDataGrid. In this case SfDataGrid performance improves compared to the previous case. Please refer the below code snippet, 




this.sfDataGrid1.UsePLINQ = true; 
 
Sample Link: https://www.syncfusion.com/downloads/support/forum/154103/ze/Sample-548163432 
We hope this helps. Please let us know, if you require further assistance on this.Regards,Vijayarasan S

The GridLock · Answer

Hi Vijayarasan ,Thanks for the suggestion.

Vijayarasan Sivanandham · Answer

Hi Khanh Dang, 
 
Thanks for the update. 
 
We are glad to know that the reported problem has been resolved at your end. Please let us know if you have any further queries on this. We are happy to help you😊. 
 
Regards, 
Vijayarasan S