I am using DataRow as TransactionItem to process some data inside an REF.
The number of columns may vary, in the sense that there may be 2 or more columns with names like this: TimePeriod 1, Timeperiod 2,…, Timeperiod X.
In short, i needto get the “X” and my thought process was to loop through the column names using an index and find out what “X” is.
In a datatable i could do this using a For Each column in DataTable, and use column.ColumnName, like so:
Is there a way to do this, assuming i have to do it on the DataRow? The column name info is there, i just need to get to it