Articles in this section
Category / Section

How do I retrieve the corresponding Datarow in the Datatable when the user selects a row in the grid?

1 min read

 

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)
Please sign in to leave a comment
Access denied
Access denied