>>>I want to organize rows in a datatable into 3 columns without scanning the table using a counter.
>>>My brain just won't work on this one.
>>>
>>>Assuming that I know rownumber r, is there a mathematical function using r that will return the proper column (1,2 or 3) for each row?
>>
>>I am not sure I understand the question.
>>
>>myDataTable.Rows[rowNumber].Columns[0]
will return value for the first column. (rowNumber is 0 based)
>
>rownumber 1 would be column 1, rownumber 2 would be column 2, rownumber 3 would be column 3, 4 would be 1, 5 would be 2, 6 would be 3, 7 would be 1 etc.
>Is there a mathematical function using rownumber that will return the column number?
int columnNumber = (row%3)+1
?