How to perform searching in whole datasource of the Grid?

By default, the grid searches for the key value only in the columns defined in the Grid column definition. In some cases, we may like to search whole dataSource for the search Key.

Solution:

We can achieve the above requirement by adding all the field names to the searchSettings.fields property of the Grid.

Example:

In the following example, we have rendered a grid with searching enabled.

1. Render the grid

JS:

MVC

ASP

2. In the DataBound event of the Grid, we can get the first JSON array of the dataSource. By traversing through this, we can get all the field names in the dataSource which we add to the serachSettings.fields property of the Grid

JS Playground link: http://jsplayground.syncfusion.com/amdr43qc

Result:

Fig 1: Initial Rendering

Fig 2: On Searching operation