Get Index Row from a DataRow, not a Datatable

[Ionut_Istrate]

Hello Everyone,
I use the Framework Template, and here in the first stage i extract DataTable from a Excel File and transform in DataRow. The problem appear when I need the Index Number from a DataRow. Without a loop. Please Help.

[reda (Reda_Marzouk)]

Hi @Ionut_Istrate

you transform DataTable into DataRow[] it’s an array of DataRows, if you want to access items in a dataRow[]
you will use the same logic of accessing items in DataTable meaning

YouDataRowArray(0)(0) will give you the first item of the first row.

Regards,
Reda Marzouk

[Ionut_Istrate]

Thank you Reda, for your answer, but it give me the first element from Excel, and i need the index…
I send you a piece of my project to see how i am doing this.IndexExtract.zip (9.5 KB)

[reda (Reda_Marzouk)]

Do you want the index meaning the Column Number?

[Ionut_Istrate]

No, the row number i want

[J0ska]

Hi,
is this what you need?

IndexExtract.zip (9.6 KB)

Cheers

EDIT: To get index of particular datarow in datatable use

index = dt.Rows.IndexOf(datarow)

[Ionut_Istrate]

Thank you J0ska. It works, but i need to do this without a For loop, because i use the FrameWorkTemplate, where i take the DataRow from GetTransactionData and process in the Process Stage…

[J0ska]

Not clear…
Why do you transform DataTable into array of DataRow?
What for do you need the index?
Cheers

[Ionut_Istrate]

Thank you for your response J0ska, but from your solution i find mine. I need to transform in DataRow because i work with FrameWork Template and if you rememeber i need to transform the DataTable in DataRow to take every time a row and process him, not in a loop. I hope you understand. The point is that i know now the solution.

Thank you all for your responses and a good day to all!