Category / Section
How do I locate the current row in my DataTable after the GridDataBoundGrid has been sorted or filtered?
You can get the currently selected row in your DataTable through the CurrencyManager even if the table is filtered and/or sorted. If "Col0" is the name of a column in the datatable, you can get at the value of this column in the current row using the below code snippet.
C#
CurrencyManager cm = (CurrencyManager) this.BindingContext[this.gridDataBoundGrid1.DataSource,
this.gridDataBoundGrid1.DataMember];
DataRow dr = ((DataRowView) cm.Current).Row;
this.label1.Text = dr["Col0"].ToString();
VB
Dim cm As CurrencyManager = Me.BindingContext(Me.GridDataBoundGrid1.DataSource,
Me.GridDataBoundGrid1.DataMember)
Dim dr As DataRow = CType(cm.Current, DataRowView).Row
Me.Label1.Text = dr("Col0").ToString()