get datasource datarow by grid row index

[sahon]

I''m handling querycellinfo event and have row index, how to get apropriate datasource row by this index? DBG can have sorting

[Administrator]

Hi,

To get the corressponding record from the given rowindex, bind the grid to the datasource. The code snippet is as follows,

CurrencyManager cm = (CurrencyManager) this.BindingContext[this.gridDataBoundGrid1.DataSource, this.gridDataBoundGrid1.DataMember];
DataRowView drv = (DataRowView)cm.Current;
DataRow dr=(DataRow)drv.Row;

Regards,
Leo.

[sahon]

but this code is only for current row, how can I get row by rowindex, f.e. to process querycellinfo

[sahon]

thank you, just found:
CurrencyManager cm=(CurrencyManager)BindingContext[dtg.DataSource, dtg.DataMember];
DataRow row;
DataView dv=(DataView)cm.List;
if (e.RowIndex>dv.Count) return;
row=dv[e.RowIndex-1].Row;