How do I retrieve the corresponding Datarow in the Datatable when the user selects a row in the grid?
If you want the datarow from the underlying datasource, then you can use the form’s bindingcontext to get the grid’s CurrencyManager. Using the CurrencyManager you can get the current selected row in the CurrentCellMoved event handler.
C#
private void gridDataBoundGrid1_CurrentCellMoved(object sender, Syncfusion.Windows.Forms.Grid.GridCurrentCellMovedEventArgs e)
{
CurrencyManager cm=(CurrencyManager)BindingContext[gridDataBoundGrid1.DataSource, gridDataBoundGrid1.DataMember];
DataRowView drv = (DataRowView)cm.Current;
this.label1.Text = drv["Col0"].ToString() + " " + drv["Col1"].ToString()+ " " + drv["Col2"].ToString()+ " " + drv["Col3"].ToString();
}
VB
Private Sub gridDataBoundGrid1_CurrentCellMoved(ByVal sender As Object, ByVal e As Syncfusion.Windows.Forms.Grid.GridCurrentCellMovedEventArgs) Handles gridDataBoundGrid1.CurrentCellMoved
Dim cm As CurrencyManager=CType(BindingContext(gridDataBoundGrid1.DataSource, gridDataBoundGrid1.DataMember), CurrencyManager)
Dim drv As DataRowView = CType(cm.Current, DataRowView)
Me.label1.Text = drv("Col0").ToString() & " " & drv("Col1").ToString()+ " " & drv("Col2").ToString()+ " " & drv("Col3").ToString()
End Sub
Here is the link with both CS and VB samples: http://websamples.syncfusion.com/samples/kb/grid.windows/GDBGRetrieveRow/main.htm