Basically, I have a DataTable as below:

Enter image description here

I want to run a method per element per row which has the parameters

AddProductPrice(SKU, Price, PriceBracket)

As an example...:

If we take the first row of data, the method will be run a potential of 16 times, once for each time Total Price X isn't null.

So for the first total price in the first row the call will be:

AddProductPrice(SKU, <Total Price 1 value>, 1)

Then for the second total price in the first row the call will be:

AddProductPrice(SKU, <Total Price 2 value>, 2)

Please note: for the National Selling element the call would be:

AddProductPrice(SKU, <National Selling value>, 16)

Is there a clever way to loop through each element in a DataRow to make the procedure more efficient?

Edit
Report