Logial way to check each colum in a row

Logial way to check each colum in a row

I may have asked this before, not sure if anyone has found a better way.

Lets say I  fetch a row into a collection called "therow"
I need to now check each column in that row, so I make make my way left to right

if "therow.C1"........
if "therow.C2"....
if therow.C2"

I have 50 columns

what i need is a "therow.C1+ 1 next column statement
or
to have therow.C1 replaced as a variable which i can build

Any ideas from anyone ?

thanks