How to read selected row from GridGroupingControl

Question

I set .TableOptions.ListBoxSelectionMode = SelectionMode.One

I just want to navigate (by mouse or keyboard) throughGridGroupingControl records and I need to read a specific cell value of selected row.

How can I do this?

Thanks

Arulpriya Ramalingam · Answer

Hi Constantin,   
   
Thanks for contacting Syncfusion support.   
   
As per the grid architecture, the selected rows will be added to SelectedRecords collection when the ListBoxSelectionMode is enabled and the selected rows will be added to SelectedRanges collection when the AllowSelection is enabled. So as per your requirement, the selected records can be retrieved from the Table.SelectedRecords collection and the cell value of selected records can be retrieved by using the GetValue() method of Record. We have created a simple sample as per your requirement. Please make use of below KB and sample,   
   
Code example:   
   




if(this.gridGroupingControl1.Table.SelectedRecords.Count > 0)   
{   
    foreach(SelectedRecord selectedRecord inthis.gridGroupingControl1.Table.SelectedRecords)   
    {   
        //To get the cell value of particular column of selected records   
        string cellValue = selectedRecord.Record.GetValue("Name").ToString();   
        MessageBox.Show(cellValue);   
    }   
}   
   
KB link: https://www.syncfusion.com/kb/5278/how-to-retrieve-and-modify-the-selected-record-in-the-grid    
UG link: https://help.syncfusion.com/windowsforms/gridgrouping/selections    
   
Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/CellValueOfSelectedRecords-968162255    
   
Regards,   
Arulpriya

CONSTANTIN BOGDAN · Answer

No, your answer solved my problem. Thank you.

Arulpriya Ramalingam · Answer

Hi Constantin, 
 
Thanks for your update.    
 
We are really happy to hear that the solution resolved your requirement.   
 
Please let us know if you have any other queries.    
   
Regards, 
Arulpriya

Unknown · Answer

Anyone have a VB sample of how to do this?

Arulpriya Ramalingam · Answer

Hi Greg, 
 
Thank you for the update 
 
We have converted the sample to VB and please make use of the below code and sample. 
 
Example code 
 




If Me.gridGroupingControl1.Table.SelectedRecords.Count > 0 Then 
            For Each selectedRecord As SelectedRecord In Me.gridGroupingControl1.Table.SelectedRecords 
                        'To get the cell value of particular column of selected records 
                        Dim cellValue As String = selectedRecord.Record.GetValue("Name").ToString() 
                        MessageBox.Show(cellValue) 
            Next selectedRecord 
End If 
 
Sample link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/VB-1105767192 
 
Please get back to us if you need any further assistance. 
 
Regards, 
Arulpriya Ramalingam