Search value in column and select row

[Thomas]

Hello,

I hope you can help me - I have not found a solution.

In a grid grouping control I have bound my database. Is it possible to search in a column (for example the ID) a value and when I found it show the position and select the whole row?

The reason is, when i make a doubleclick on a row a second windows opens to make changes. When I click save the windows close and the GGC is reloading (more user work on the database) the data from the database. The GGC shows the list on the top but user would like to see the last edited row.

Thanks for your support.

Thomas

[Mohanraj Gunasekaran]

Hi Thomas, 

 

Thanks for using Syncfusion product. 

 

To find the cell value based on the column name, you could use the Record row index using GetRowIndex method and select that record using SetSelected method in QueryCellStyleInfo event. Please refer the following code example, 

 

Code example 

this.gridGroupingControl1.QueryCellStyleInfo += GridGroupingControl1_QueryCellStyleInfo; 

 

int rowIndex = -1; 

private void GridGroupingControl1_QueryCellStyleInfo(object sender, GridTableCellStyleInfoEventArgs e) 

{ 

    if (e.TableCellIdentity == null || e.TableCellIdentity.Column == null) 

        return; 

             

    if (e.TableCellIdentity.DisplayElement.Kind == Syncfusion.Grouping.DisplayElementKind.Record) 

    { 

        var record = e.TableCellIdentity.DisplayElement.GetRecord(); 

        if (e.TableCellIdentity.Column.Name == "Id" && record.GetValue("Id").ToString().Equals("E20")) 

        { 

            rowIndex = e.TableCellIdentity.DisplayElement.GetRowIndex(); 

        } 

 

        if (!record.IsSelected() && record.GetRowIndex() == rowIndex) 

        { 

            record.SetSelected(true); 

        } 

    } 

} 

 

Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/CS-1958590972  

 

Regards, 

Mohanraj G