Need to convert System.Data.DataRow to System.Collections.IEnumerable

[michaelamay0 (Michael J Amay)]

I have the row and want to loop through each item inside of it; I was thinking of using a For Each activity to loop but it doesn’t accept DataRow directly it has to be in IEnumerable format, so I need to convert the DataRow object to an IEnumerable object.

[ermanoj3101 (MANOJ)]

Hi @michaelamay0 ,

Have you tried like this in foreach

[ppr (Peter Preuss)]

@michaelamay0

I have the row and want to loop through each item inside of it;

in that case we are using row.ItemArray and let for each typeArgument: Object
So we will iterate over all column values

[michaelamay0 (Michael J Amay)]

Hi @ermanoj3101 yes, if you check on your end by making the dr object type data.row it will create an error message as the For Each only take IEnumerable object to iterate through; data.row is not a IEnumerable.

[michaelamay0 (Michael J Amay)]

Worked like a charm thx!

[ermanoj3101 (MANOJ)]

ohh, is it?

Let me check.