Hi
I'm trying to retrieve the value of a cell from a row in SFDatagrid. I'm using VB.Net and the code example provide at
Selection | DataGrid Control for Windows Forms | Syncfusion
My code is therefore as follows:
Private Sub Button4_Click(sender As Object, e As EventArgs) Handles Button4.Click
Dim cellValue As String
Dim rowIndex As Integer = 5
Dim columnIndex As Integer = Me.dgvPersonTable.TableControl.ResolveToGridVisibleColumnIndex(2)
If columnIndex < 0 Then
Return
End If
Dim mappingName = dgvPersonTable.Columns(columnIndex).MappingName
Dim recordIndex = dgvPersonTable.TableControl.ResolveToRecordIndex(rowIndex)
If recordIndex < 0 Then
Return
End If
If dgvPersonTable.View.TopLevelGroup IsNot Nothing Then
Dim record = dgvPersonTable.View.TopLevelGroup.DisplayElements(recordIndex)
If Not record.IsRecords Then
Return
End If
Dim data = (TryCast(record, RecordEntry)).Data
cellValue = (data.GetType().GetProperty(mappingName).GetValue(data, Nothing).ToString())
Else
Dim record1 = dgvPersonTable.View.Records.GetItemAt(recordIndex)
cellValue = (record1.GetType().GetProperty(mappingName).GetValue(record1, Nothing).ToString())
End If
MessageBox.Show(cellValue, "Value in cell (" & rowIndex & ", " & columnIndex & ")")
End Sub
When executed this returns an unhandled exception as follows:
System.NullReferenceException: 'Object reference not set to an instance of an object.'
System.Type.GetProperty(...) returned Nothing.
The error is being thrown at the line "cell value = (record1.getType().......etc".Can anyone suggest where this code is going wrong please.
Thanks and regards
Michael Bond
