Articles in this section

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

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Access denied
Access denied